4 Replies Latest reply: May 24, 2016 5:51 AM by Carlos Daniel RSS

    Rank top 2 of several columns

    Carlos Daniel

      Hi there,

       

      Let's say that i have the following data:

       

      dimensionc1c2c3c4
      dim1258
      dim1359
      dim0268

       

       

      How can i produce a bar chart, that shows, for the dimension, the highest average columns? In this case, the chart would display two bars, the average of C3 and the average of C4.

       

      My guess is that, for a bar chart, the dimension would be the column dimension, and i would have two calculated measures, but i'm unsure what the formula for these would be.

       

      Thanks for the help.