2 Replies Latest reply: Feb 16, 2011 11:36 AM by Les Backman RSS

    Relative sales in Pivot Chart

      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?

       

      error loading image