ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table Row Totals (https://www.excelbanter.com/excel-discussion-misc-queries/121756-pivot-table-row-totals.html)

Les

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


All times are GMT +1. The time now is 03:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com