Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
For this data set
I want to return The maximum "Tonne" =[10] for each line
I tried the following:
Max({<[DocType]=,[Condition type]=,[SubDoc]=>}Quantity)
So for each Contract I am looking to return the max quantity => on each line [So every line must return 10]
It looked that you didn't want to ignore selections else the dimensionality within the table. This could be reached with TOTAL like: max(TOTAL Quantity) or maybe max(TOTAL <Dim1, Dim2> Quantity) whereby Dim1 + Dim2 are just place-holder for dimensions which should be further respected.
- Marcus