View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Les Les is offline
external usenet poster
 
Posts: 240
Default Pivot Table Row Totals

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