Calculation Headeach

[Capt_Flam]

I Have this type of data

And I want to run a repport like this 

The first repport work fine, but when i collapse the society, the cumulative to do is not the cumulative I want (The cumulative for all the society regardless the month).

If you have ideas please don't hesitate to give me your feedback.

Kind regards

[Capt_Flam]

Hi Wisdom Wu,
Many thanks to keep my problem in mind, but the solution you give me, it's the solution I have and I need for ABC/A 130 for 2024-04, and for ADD/A 80 for 2024-04 and 2024-05 to calculate a good percentage for the avancement for ABC/A and ADD/A.

[Anonymous]

Hi,

Based on the description, try using the following measure formula and drag the measure to the matrix Values.

CumulativeToDo = 
CALCULATE(
    SUM('Table'[Global To Do]),
    FILTER(
        ALL('Table'[Month]),
        'Table'[Month]<= MAX('Table'[Month])
    )
)

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Capt_Flam]

Hi Wisdom Wu,
Many thanks to keep my problem in mind.
The solution you give to me couldn't be use, because I need a non cumulative to do, just the max to do for everyone, or when collapse the max for the Society, or for the Order.
Many thank for your help.

[Anonymous]

Hi @Capt_Flam ,

Based on the testing, please drag the Global To Do to the Values.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.