Determine Table Column Max Value?

[richardouellett]

The following formula (Dur) gives me the summary “Duration” column average total 35.03 in the table below. I am trying to create a formula to obtain the maximum value in the Duration column; in this case the value would be 171.87.  Can you help me?

=$(=avg((i1_7))

[sunny_talwar]

May be this:

Max(Aggr(YourExpressionofDuration, YourChartDimensions))

[richardouellett]

That did not work as instructed; do you have more information/explanation?

[sunny_talwar]

What is your expression for Column Dur?

[richardouellett]

Sunny, below is the result of your formula.  I have highlighted Dur in yellow.

[sunny_talwar · Accepted solution]

Try this:

Max(TOTAL Aggr(YourExpressionofDuration, YourChartDimensions))

Max(TOTAL Aggr(Avg(i1_7))*1, Sequence))