This content has been marked as final. Show 2 replies
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?