View Single Post
  #2   Report Post  
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