#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 79
Default Pivot Table Question

Hello,

I have a Pivot Table with a field that represent gross units and returns.
Each account has 1 row representing gross units and 1 representing returns.
I'd like to add a row showing the return %, but I'm not sure how it would be
possible within the table?

Account Transaction Type Jan Feb Mar
01234 Gross 10 7 12
Returns -2 -1 -4
01235 Gross 25 15 18
Returns -3 -7 -4
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,180
Default Pivot Table Question

Excel 2007 PivotTable
Calculated Item, %
http://www.mediafire.com/file/imzmhm...10_15_09b.xlsx
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table question erick-flores Excel Discussion (Misc queries) 6 November 17th 06 10:39 PM
Pivot table question [email protected] Excel Discussion (Misc queries) 1 December 6th 05 12:02 PM
Pivot Table Question : If statment in Pivot Table?? seve Excel Discussion (Misc queries) 2 November 22nd 05 01:00 AM
Pivot Table Question SVTFern Excel Worksheet Functions 1 November 11th 05 07:13 PM
Pivot Table Question Jennifer Excel Discussion (Misc queries) 1 July 13th 05 12:27 PM


All times are GMT +1. The time now is 03:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"