Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be you can chage sum(Sales)/sum(TOTAL Sales) to
sum(Sales)/sum(TOTAL<Product> Sales)
May be you can chage sum(Sales)/sum(TOTAL Sales) to
sum(Sales)/sum(TOTAL<Product> Sales)
Hi Taufig
thanks for your fast response .
it works fine
gidon