Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all,
i have a pivot table with 2 dimension - Year & salesman and i want to see share of sales (year by year) between the salesmen; the problem is when i sellect just a salesman, or less than all of them because share becomes 100%; if i put {1} in formula is not ok because it calculates and solves share for each salesman even i select just one of them but is wrong when i want these situation not for all product and i select just one, or two
also, in reality i have a cyclic Year/Month and i want a formula ok for both situation
i attached the document
Thanks,
Cosmin
Cosmin,
Try putting your {1} or {<salesman>} ignore set in the denominator only.
Regards,
Vlad
Cosmin,
Try putting your {1} or {<salesman>} ignore set in the denominator only.
Regards,
Vlad
it's ok now; i used Sum({<salesman>}.....
many thanks