Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - add new group to original data | Excel Discussion (Misc queries) | |||
adding more data to pivot table. | Excel Worksheet Functions | |||
Sort pivot table field (droplist) by month or original data | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
How do I restore original Pivot Table data? | Excel Discussion (Misc queries) |