Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Pivot chart issue | Charts and Charting in Excel | |||
Pivot Chart - default chart type | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
pivot table multi line chart | Charts and Charting in Excel |