SubTotal and Total in pivot table

[gidon500]

Hi Guys

my customer  wants to know the portion 

of sales per sales person , by product type  ,  

in on pivot table  . 

if I chose one product line i get the correct data . 

if in one table I get portion ver all sales ,

enclosed in a  doc with the object and a sample of how i want to see it when all product are showed .

i am not sure i am clear but the sample is very clear   

thanks

gidon

[Taoufiq_Zarra · Accepted solution]

@gidon500 

May be you can chage sum(Sales)/sum(TOTAL Sales) to

sum(Sales)/sum(TOTAL<Product> Sales)

[gidon500]

Hi Taufig 

thanks for your fast response .

it works fine

gidon