topic Re: Sum on Max per dimension in App Development

Sum on Max per dimension

SamKng — Mon, 20 Dec 2021 21:38:40 GMT

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

Re: Sum on Max per dimension

jochem_zw — Thu, 16 Jan 2020 21:12:04 GMT

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

Re: Sum on Max per dimension

Kushal_Chawda — Thu, 16 Jan 2020 21:31:16 GMT

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

Re: Sum on Max per dimension

SamKng — Fri, 17 Jan 2020 07:03:09 GMT

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?

Re: Sum on Max per dimension

jochem_zw — Mon, 20 Jan 2020 08:12:30 GMT

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

Re: Sum on Max per dimension

SamKng — Mon, 20 Jan 2020 14:38:58 GMT

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

Re: Sum on Max per dimension

Kushal_Chawda — Mon, 20 Jan 2020 15:02:34 GMT

try this

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

Re: Sum on Max per dimension

SamKng — Mon, 20 Jan 2020 16:44:34 GMT

Clever, that works, thanks a lot! 🙂