Hi All,

I am having a hard time with a pivot table. I want to append a column on to
the side of a pivot table and have that column drill down and up with the
rest of the pivot table. The column will contain a calculation that is a % of
but on the subtotals not just of the total. I read somewhere that it is not
possible to use the pivot table formula '%of' on subtotals, so I find putting
the calculation in a column beside the pivot table is my only option. That
would be all well and good if this column would drill up and drill down with
the rest of the pivot table.. but it doesn't. Any suggestions?

Thanks!
John