Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can anyone help please?
I have a pivot table attached to an Access query. I have 2 data fields that work perfectly well. I'm trying to add a 3rd set of data that calculates the percentage of the second set of data for the individual data field. I can work out the percentage for the total column by selecting '% of column' from the 'show data as' drop down box. This is very close to what I'm after but for each itemin the Row field. Regards Les. is the percentage of set of data 2 All is working well but what I need to do |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table % of Totals | Excel Discussion (Misc queries) | |||
Pivot Table Totals Incorrectly Summed | Excel Worksheet Functions | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Grand Total on Pivot Table turned on but no totals showing | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) |