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