Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
gidon500
Creator II
Creator II

SubTotal and Total in pivot table

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

 

1 Solution

Accepted Solutions
Taoufiq_Zarra

@gidon500 

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

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

 

Capture.JPG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

2 Replies
Taoufiq_Zarra

@gidon500 

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

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

 

Capture.JPG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
gidon500
Creator II
Creator II
Author

Hi Taufig 

thanks for your fast response .

it works fine

gidon