Hello,
I know that when adding a formula column to a table you simple enter the formula in the first data cell and it auto-populates the column. What can I do with a pivot table to get a similar result? I want to add a column after the grand total to double the grand total without having to alter the data. Example, I have Apples and Grapes as my columns and red and green as my rows. I want to take the grand total of everything that's red and multiply it by 2 and have it become part of the pivot table. I tried adding a calculated field but that drops in an extra column for each fruit.
Any ideas?
Thanks
Bookmarks