Sum on Max per dimension

[SamKng]

Dear all,

I have the feeling that the solution for my problem should be very easy, I however did not find any solution in several related threads yet.

Please have a look at the following data:

What I'd like to see is:

- Yield per Order and Operation in each row

- Sum of Max(Yield) per Order in the total row

The above simple approach basically suits to my needs, however with one important exception: the 0 in the second row  should be 500 and the 0 in row 4 should be 1000. 

I hope my explanations are clear, otherwise let me know.

Any input is highly appreciated. 

Best regards, jovie

[jochem_zw]

how about sum(aggr(max(Yield),Order,Operation))

[Kushal_Chawda]

Looks like both Yield and Max Yield gives same output. Can you please elaborate more?

[SamKng]

Thanks for your idea. That helps for the rows, but the the total is then wrong:

The total should show the sum of the max per order (accross operations), which means:

Max of order A: 1'500

Max of order B: 2'000

---------------------------

Sum of both: 3'500

Any other ideas?

[jochem_zw]

sum(distinct aggr(Max(Total <Order> Yield),Order,Operation))

[SamKng]

Thanks for this new idea. The result is a bit closer to what I need, but not 100% there yet:

[Kushal_Chawda · Accepted solution]

try this

=if(sum(aggr(max(Yield),Order))=0,sum(Yield),sum(aggr(max(Yield),Order)))

[SamKng]

Clever, that works, thanks a lot! 🙂