15 Replies Latest reply: Dec 4, 2017 10:00 AM by Sunny Talwar RSS

    how highest value of Dimension A in Dimension B

    Max Maudin

      Hi all

       

      I have 2 dimensions: the first is Dimension "Problem" and the 2nd "Reaction". The Goal is to Show the highest value (Count) of Problem in the Dimension "Reaction". For example the most often Problem of customers is A

       

      The Pie Chart "Reaction" must Show the different reactions of the customers with Problem A.

       

      Atm I only get the highest value of the Problem by

       

      max(aggr(count({$<

      Source={'V2}>}#),Problem))

       

      But I need the Dimension - not the value. Do you have any idea how i could works?

       

      Thanks,

      Max