Hi,
I have the following data in a pivot table:
MODEL | Segment | TYPE | SUB_TYPE | Engine | sum ( Measure ) |
A4 | D | A | A1 | aaa | 879 |
A4 | D | A | A2 | bbb | 14 |
A4 | D | A | A3 | ccc | 828 |
A4 | D | A | A4 | ddd | 20 |
A4 | D | A | A5 | eee | 0 |
A4 | D | A | A6 | fff | 63 |
A4 | D | A | A7 | ggg | 1 |
A4 | D | B | B1 | hhh | 8 |
A4 | D | B | B2 | iii | 10 |
A4 | D | B | B3 | lll | 1 |
A4 | D | B | B4 | mmm | 0 |
A4 | D | B | B5 | nnn | 4 |
A4 | D | B | B6 | ooo | 2 |
A4 | D | B | B7 | ppp | 0 |
My issue is to visualize Engine description (string) according to the max value of Measure, as in the below table.
MODEL | Segment | TYPE | SUB_TYPE | Engine | sum ( Measure ) | max(TOTAL<TYPE,MODEL> aggr(sum(Measure),MODEL,TYPE,SUB_TYPE)) |
A4 | D | A | A1 | aaa | 879 | 879 |
A4 | D | A | A2 | aaa | 14 | 879 |
A4 | D | A | A3 | aaa | 828 | 879 |
A4 | D | A | A4 | aaa | 20 | 879 |
A4 | D | A | A5 | aaa | 0 | 879 |
A4 | D | A | A6 | aaa | 63 | 879 |
A4 | D | A | A7 | aaa | 1 | 879 |
A4 | D | B | B1 | bbb | 8 | 10 |
A4 | D | B | B2 | bbb | 10 | 10 |
A4 | D | B | B3 | bbb | 1 | 10 |
A4 | D | B | B4 | bbb | 0 | 10 |
A4 | D | B | B5 | bbb | 4 | 10 |
A4 | D | B | B6 | bbb | 2 | 10 |
A4 | D | B | B7 | bbb | 0 | 10 |
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