Get Maximum number against year in a transaction data?

Arnab116
Arnab116
in Modeling

Hi,

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:

image.png

Solution I want :

Against FY24 I want 7 for FY23 I want 2.

Thanks.

Best Answer

  • rob_marshall
    rob_marshall
    edited June 2023 Answer ✓

    @Arnab116

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

    Above Module Name.Number[MAX: Year Format]

Answers

Categories