Pivot Table and adding a % column, that is not in original data
Which EXCEL version?
"MarkArtillery" wrote:
Hi, Is it possible to add a column for % calculations when the % column is
not in original data? To clarify, my original data is as follows:
Produt Sales Returns Date
A 5 June
B 6 June
A 1 July
A 1 September
B 1 November
When I run the pivot table, one of the columns I'm then looking to get is a
total % of returns over sales , but I cant see how to include in a Pivot
table. I can add it outside of the table, but that has problems when the
table is refreshed etc, as it frequently needs to be.
Thanks for any help
|