pivot table - calculate share correctly

[#1]

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

[vgutkovsky · Accepted solution]

Cosmin,

Try putting your {1} or {<salesman>} ignore set in the denominator only.

Regards,

Vlad

[#3]

it's ok now; i used  Sum({<salesman>}.....

many thanks