2 Replies Latest reply on Jan 21, 2016 11:36 PM by mark.vandewielle

    Profit bin histograms - table calculation to normalize vertical axis?

    mark.vandewielle

      I want to compare profitability histograms for different categories as in the Superstore screenshot below.

       

      Some of the histograms become hard to read because the volume within that category is small.  I would like the histogram to be based on volume, but in order to make the histograms reasonable I would like each of the vertical axis to be sized independently.  I've understood from other threads that that is currently not possible, so then I was hoping to use a table calculation to show the histograms as a percentage of the max value for that category.  I tried a number of different things but couldn't find the magical formula to allow me to say "Percentage of... Max... along Table (across)".  Can anyone with more experience in table calcs help?  Or do I need to use a calculated field with LOD calculations for this?