| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
