1 Reply Latest reply: Apr 9, 2012 4:45 PM by Joshua Goldner RSS

    Relative percentages within chart dimension

    David Talbot

      This is probably really simple but i can't seem to find the solution. 

       

      Below on chart 1 I would like each Type to be on a scale of a 100%.  If i drill down, chart 2, I get what I would like at the higher level.  I have selected "relative", and the formula is a sum of an amount that can be positive or negative.  Each negative will have a corresponding positive, so i would like the % of negatives & positives.

       

      Picture1.png