Relative sales in Pivot Chart

[#1]

Hi,

I am trying to create the following pivot chart with two dimension: salesman and market

my first expression is straight forward, sum(sales), the second expression should be calculating the % of sales for that market segment, relative to the other market segments. I tried sum(sales)/ sum(TOTAL sales) but that gives me relative to all other salesman. Any ideas?

[#2 · Accepted solution]

Try this:

SUM(Sales) / SUM (TOTAL <Salesman> (Sales)

Sorry I missed the second dimension BRB also above should be SUM(Sales) / Sum (TOTAL <Salesman> Sales)

SUM(Sales) / Sum( TOTAL <Salesman , Market> Sales)

[#3]

Thanks! Thought I had thought I tried set analysis but i guess not!