Max value of nested chart aggregation

[moda1023]

Hello everyone :-),

so my pivot table is similiar to this one.

                                                              Fields

Area	1	2	3	4
A	91	98	43	56
B	25	33	50	70
C	28	74	12	14
D	17	52	64	34
E	14	25	32	19

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

Area	1	2	3	4
A	98	98	98	98
B	70	70	70	70
C	74	74	74	74
D	64	64	64	64
E	32	32	32	32

But what i would like to see is:

                         Fields

Area	1	2	3	4
A	98	98	98	98
B	98	98	98	98
C	98	98	98	98
D	98	98	98	98
E	98	98	98	98

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

Hope someone can help me.

Kind regards

[moda1023 · Accepted solution]

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.