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