Max value of nested chart aggregation

moda1023 — Thu, 25 Oct 2018 11:57:54 GMT

Hello everyone :-),

so my pivot table is similiar to this one.

Fields

This is allready displaying the sum of the activity of parts that are stored in the area (a,b,c,d,e) in the corresponding field(1,2,3,4).

So the formula right now is just sum(activity). The dimensions are Area and Fields. I just want to get the highest value in the table.

So my first try was: max(aggr(sum(activity), Area, Fields)). But this just shows me the same values that are displayed above.

even max(total aggr(sum(activity), Area, Fields)) just calculates something, that i'm not able to understand.

At least if i use max(total <Area> aggr(sum(activity), Area, Fields)) i see this:

Fields

But what i would like to see is:

Fields

Need this in order to calculate a variable background colour with ARGB.

Hope someone can help me.

Kind regards

Re: Max value of nested chart aggregation

moda1023 — Fri, 26 Oct 2018 10:57:25 GMT

After regarding my values again in a separate table, i noticed i had some null values.

So this did the trick for me :

max(total aggr(sum({<Area ={"*"}-{}>}activity),Area,Fields))

Maybe someone has a more elegant way of doing that.