topic SubTotal and Total in pivot table in QlikView

SubTotal and Total in pivot table

gidon500 — Sat, 13 Jun 2020 07:45:23 GMT

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 — Sat, 13 Jun 2020 09:48:11 GMT

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

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

gidon500 — Sat, 13 Jun 2020 10:01:39 GMT

Hi Taufig

thanks for your fast response .

it works fine

gidon