Applying Percentages to a Pivot Table
 

Hello,

I have a pivot table which is drawing it's data from Microsoft Query.
Currently it is bringing back values which I am wanting to display in a pivot
table as percentages as follows:

Product Category 1 Category 2 Total
Clients Accounts Clients Accounts Clients
Accounts
P1 25% 50% 75% 50% 100% 100%
P2 60% 20% 40% 80% 100% 100%
etc etc

Please would you advise how this can be done?

Thanks very much,

Dan