2 Replies Latest reply: Jul 10, 2013 3:03 AM by Steffen Hasenkopf RSS

    AGGR Function Problems with 2 expressions or 2 dimensions

      Hello,

       

      i try to solve following problem with the following dataset. the data produces duplicates with an counter. That is the example dataset:

       

       

      OrderDateCounterValue
      A01.01.2013110
      A02.01.2013210
      A03.01.2013310
      A04.01.2013410
      B01.01.2013115
      B02.01.2013215
      B03.01.2013315
      C01.01.2013120
      C02.01.2013220

       

      To get the value of the orders i use following formula, which is correct:

       

      sum ( aggr ( max (Value),Order)) = 45

       

      No there is the problem. I want to build a graph (table or pie chart) which shows the MAX Counter and the Value of it. The Formula

       

      sum ( aggr ( max (Value),Order, Counter )) doesn´t show the correct results. It should be like:

       

      Counter Value

      4 = 10

      3 = 15

      2 = 20

       

      How can i use the AGGR Formula with 2 expressions (max (Value)) and (max (Counter)).

       

      PLEASE is there anybody with an idea? 

       

      Kind regards

      jezze