Story Report Calculated Column finding the MAX

[maseitner]

Dear colleagues,

we need to find a way to identify the highest or latest value in a table by a formuala. In Excel you would pick the MAX formula BUT from what we tried in story report calculated column it is NOT Possible to use MAX formula.

Do you happen to have an idea here?

Thanks and BR

Martin

[JeroenA]

Hi maseitner,

I recommend using a crosstab table in your story. You can then create a calculation of type aggregation and use the MAX function. This should work.

Kind regards,

Jeroen

[maseitner]

Hi Jeroen, thanks a lot for your idea. I will try that