Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old March 3rd 06, 10:40 AM posted to microsoft.public.excel.misc
cereldine
 
Posts: n/a
Default two Pivot Tables One pivot chart


hi, I have a pivot table that shows the % difference for a groups
forecasted results and a pivot table that shows % difference for actual
results.

Is there any way to have both of these records sets shown in one table
and then one chart without going down the path of multiple
consolidation ranges? I'm not particually well versed in this area and
following this path does not show the data as i would like it e.g I
need to see the actual values of the two pivot tables rather than a
count or sum of them.


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=518636


  #2   Report Post  
Old March 3rd 06, 02:32 PM posted to microsoft.public.excel.misc
robert111
 
Posts: n/a
Default two Pivot Tables One pivot chart


I don't fully understand your query but if for January the target was
100, the forecast was 97 and the actual was 95, your 2 pivot tables
presumably show
-3% and -5%


I suggest you ditch the pivot tables and replace them with 1 sumproduct
table

=sumproduct((a1:a5=deptA)*(b1:b5="january")*(c1:c5 0)) is the type of
equation assuming your %diff_forecast_from_target figures are in column
C


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=518636



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
Dynamically changing several pivot tables at once Jason Excel Discussion (Misc queries) 3 December 16th 05 03:50 PM
Pivot chart issue James Charts and Charting in Excel 8 September 13th 05 12:35 PM
Pivot Chart - default chart type Rav99 Excel Discussion (Misc queries) 4 September 6th 05 01:20 AM
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 01:03 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 01:48 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017