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.


Best Answer

  • rob_marshall
    edited June 2023 Answer ✓


    In another module dimensionalized by your Year (the members in Year Format), try this formula

    Above Module Name.Number[MAX: Year Format]