P
Paul
I added a calculated field (year-to-year growth rate) to my
pivot table using the Calculated Item feature. The new
growth rate field works fine except for Grand Total row,
where instead of calculating a growth rate for the data in
that row , the growth rates from all the above rows are
just added together, showing a number that's not an
accurate growth rate for the Grand Total row. Any
work-around for this issue.
pivot table using the Calculated Item feature. The new
growth rate field works fine except for Grand Total row,
where instead of calculating a growth rate for the data in
that row , the growth rates from all the above rows are
just added together, showing a number that's not an
accurate growth rate for the Grand Total row. Any
work-around for this issue.