Max value in a time dimension
I'm trying to get the maximum value of the item test1 in the time range FY19-FY30 and then use that value in an operation in item2. Any idea?
In the example screenshot I attached, the maximum value of item 1 is 10 (FY30). In item2, I would like to do the operation 10*line item3.
Any suggestions to obtain the max value (10)????