0 Replies Latest reply: Jan 28, 2013 10:17 AM by Davide Ducco RSS

    String related to max value

    Davide Ducco

      Hi,

      I have the following data in a pivot table:

      MODELSegmentTYPESUB_TYPEEnginesum ( Measure )
      A4DAA1 aaa879
      A4DAA2

      bbb

      14
      A4DAA3ccc 828
      A4DAA4ddd 20
      A4DAA5 eee0
      A4DAA6 fff63
      A4DAA7 ggg1
      A4DBB1 hhh8
      A4DBB2 iii10
      A4DBB3 lll1
      A4DBB4 mmm0
      A4DBB5 nnn4
      A4DBB6 ooo2
      A4DBB7 ppp0

       

       

      My issue is to visualize Engine description (string) according to the max value of Measure, as in the below table.

       

      MODELSegmentTYPESUB_TYPEEnginesum ( Measure )max(TOTAL<TYPE,MODEL> aggr(sum(Measure),MODEL,TYPE,SUB_TYPE))
      A4DAA1aaa879879
      A4DAA2aaa14879
      A4DAA3aaa828879
      A4DAA4aaa20879
      A4DAA5aaa0879
      A4DAA6aaa63879
      A4DAA7aaa1879
      A4DBB1bbb810
      A4DBB2bbb1010
      A4DBB3bbb110
      A4DBB4bbb010
      A4DBB5bbb410
      A4DBB6bbb210
      A4DBB7bbb010

       

      I got the max of the sum(Measure) grouped by Type, but I'm not able to visualize the correct string.

      Could anyone help me?

       

      Thanks a lot,

      Davide