7 Replies Latest reply: Jun 2, 2012 11:16 AM by Toni Kautto RSS

    Most frequent table value for a dimension

    Alexis VAILLANT

      Hi all,


      I have a table like:

      Customer | Item | item category | price | qty


      I would like to get as result something like

      Cutomer (as a dimension) | Turnover (as qty * price) | most frequent ordered category


      The result is provided through a table drawn as a chart.


      and I don't have any idea on how to turn the expression to get that "most frequent ordered category"


      Any idea?

      Thanks in advance for your usual support