5 Replies Latest reply: Oct 31, 2016 4:47 PM by Sunny Talwar RSS

    Creat Table Chart with Top 3 in expression

    Eduardo Calcabrini

      Hello there,

       

      I was trying to create a table chart and I don't know if it's possible.

       

      Let's suppose I have the following data:

      DATA.png

       

      I want a chart where I can watch in a column the Sum Sales (No problem on this).
      In other column some kind of top 3, showing which Subgroup have higher sales.

       

      For example:

      Chart.png


      I try to use the rank function but without much success, anybody can send me a clue??

      Thanks!