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:





      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.