Pivot Table column to column measurement

[Mel]

In my raw data used to compile my pivot table, there is a
column (Let's called it "X1") which measure in percentage
terms the month-on-month performance against 2 previous
columns (i.e months).
But when the pivot table is created with the Column X1 in
the data field of the pivot table, it is not intuitive to
assess the 2 months information to get the right
percentage measurement.
I solved that with a calculated field in the pivot table
but came up with another limitation which is that the
formula in the calculated field does not compute into my
subtotal compilation on the Grand Total row.

Does anyone know how to either solve the
1) Wrong computation of Column X1?
2) or the omitted subtotals on the Grand Total Row?
(see ???)

Data Set as displayed below.
Data
Ctries Pdts Feb Mar Col X1 Cal Field
a aa 4 5 25% 25%
bb #DIV/0!
cc 35 83 3571% 137%
a Total 39 88 3596% 126%

b aa 16 82 927% 413%
bb 100 23 -79% -77%
cc 4 0 -100% -100%
b Total 120 105 748% -13%

c aa 21 20 43% -5%
bb 63 467 7061% 641%
cc 35 76 117% 117%
c Total 119 563 7222% 373%

d aa 78 2 -97% -97%
bb 6 66 1000% 1000%
cc #DIV/0!
d Total 84 68 903% -19%

e aa #DIV/0!
bb 2 4 100% 100%
cc #DIV/0!
e Total 2 4 100% 100%

aa Sum 119 109 898% ???
bb Sum 171 560 8083% ???
cc Sum 74 159 3588% ???
Grand Total 364 828 12568% 127%

 

[BrianB]

I think that the only way of getting this sort of thing to work is t
have columns outside the pivot table to do the job