Posted to microsoft.public.excel.misc

Kevin

external usenet poster

Posts: 504

Pivot Table Calculation

Hi

Is it possible for Pivot Tables to calculate differences between 2 columns.
For instance I have a a table showing a range of dates down the x-axis (row).
I have limited the column axis to only 2 values. I have removed "Show grand
totals for rows" as this adds the 2 values together. I actually want to see
the difference between the 2 values rather than their sum?
--
Kevin

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 % Calculation	cockatoo	Excel Discussion (Misc queries)	0	October 21st 08 05:24 PM
Pivot Table Calculation	Silena K-K	Excel Discussion (Misc queries)	4	March 17th 08 06:48 AM
Pivot Table Calculation	Tim Kuhn	Excel Worksheet Functions	1	December 21st 07 02:03 AM
pivot table % calculation	boris	Excel Worksheet Functions	0	March 3rd 05 06:40 PM
Pivot Table % calculation	CSAH	Excel Worksheet Functions	1	January 14th 05 04:33 AM

All times are GMT +1. The time now is 11:31 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us