Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to get rank for the cross table. This is my code for the max value:
=Pick( Match(Max(Values), sum(bob), sum(pierre), sum(brain)),'C:\first.png', 'C:\Second.png', 'C:\Third.png')
it works with one selection but not for multiple selection Ej (R1, R2, R3)
Cross table
Region Seller Values
R1 BOB 12
R1 PIERRE 23
R1 BRAIN 47
R2 BOB 32
R2 PIERRE 30
R2 BRAIN 42
...
Table original
Region BOB PIERRE BRAIN
R1 12 23 47
R2 32 45 10
R3 25 21 20
how obtain the first, second and third ?
Please help me. Thx
I just solve the problem. This is my solution:
=IF(Max(aggr(sum(Ventas),Vendedor)) = sum(Vendedor_1),sum(Vendedor_1),
IF(Max(aggr(sum(Ventas),Vendedor)) = sum(Vendedor_2),sum(Vendedor_2),
IF(Max(aggr(sum(Ventas),Vendedor)) = sum(Vendedor_3),sum(Vendedor_3))))
Thanks for the reply
Rau ,
For this you can use system fields to get the 1 2 3 .
Can you please explain that whatyou want in your layout?
I just solve the problem. This is my solution:
=IF(Max(aggr(sum(Ventas),Vendedor)) = sum(Vendedor_1),sum(Vendedor_1),
IF(Max(aggr(sum(Ventas),Vendedor)) = sum(Vendedor_2),sum(Vendedor_2),
IF(Max(aggr(sum(Ventas),Vendedor)) = sum(Vendedor_3),sum(Vendedor_3))))
Thanks for the reply