Get Maximum number against year in a transaction data?
I have transaction data where i have a period formatted line item with the year and a number formatted line item called Number. I want the maximum number against each year in the Max column.
I tried the Number[MAX:Year] but it didn't work. So how can I get the maximum number against each Year?
Attaching the screnshot of the transaction data below:
Solution I want :
Against FY24 I want 7 for FY23 I want 2.