Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
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