Adding a formula column based on the pivot table's Grand Total column

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

You can create 2 pivot tables; one for each color, and add a calculated field for each table! or use a filter on the same table.
Otherwise you can send us a file to figure out how it works, and how it can be solved!