Hello,
I have a pivot table set out as below, with the dates grouped by Month, Qtr and Year. The pivot table is linked from 2 data sources
<tbody>
</tbody>
I am having problems with the % Diff columns. Currently I have set up a column in the original data to work it out, but when I collapse the Qtr or Year, it becomes a sum of the %'s:
<tbody>
</tbody>
I can get it to work using a calculated field, but only if the pivot table has 1 set of source data. And ideally I would like to have both sources feeding in.
I have a pivot table set out as below, with the dates grouped by Month, Qtr and Year. The pivot table is linked from 2 data sources
QTR4 | |||||||||
OCT | NOV | DEC | |||||||
FC | AC | %DIFF | FC | AC | %DIFF | FC | AC | %DIF | |
APPLE | 100 | 110 | 10% | 50 | 100 | 100% | 70 | 50 | -29% |
ORANGE | 20 | 40 | 100% | 20 | 20 | 0% | 30 | 25 | -20% |
<tbody>
</tbody>
I am having problems with the % Diff columns. Currently I have set up a column in the original data to work it out, but when I collapse the Qtr or Year, it becomes a sum of the %'s:
QTR4 | |||
FC | AC | %DIFF | |
APPLE | 220 | 260 | 81% |
ORANGE | 70 | 90 | 80% |
<tbody>
</tbody>
I can get it to work using a calculated field, but only if the pivot table has 1 set of source data. And ideally I would like to have both sources feeding in.