two Pivot Tables One pivot chart

[cereldine]

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.

 

[robert111]

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