Cumulative sum measure

[JC2022]

Hi,

I have some trouble with creating a measure. I have the fields below from 2 tables. Date and MonthYear from a calendar table. The other columns are from a different table with obviously a relationship between Date columns.

Now I am trying to create a cumulative sum measure of the "Hours to do per workday". But this measure should be able to filter on a speficic Category and Team. But when removing a (for example) Team filter it should cumulate the sum per Category. And when removing the Category and Team it should cumulate the sum per Date. Etc.

Is anyone able to help me? 

Current fields:

Date	MonthYear	Category	Team	Project	Hours to do per workday
8-7-2024	jul-24	Category A	Team A	GH761008	0,90
8-7-2024	jul-24	Category B	Team I	AT511552	0,80
8-7-2024	jul-24	Category B	Team D	GH760640	0,85
8-7-2024	jul-24	Category C	Team C	AT510847	0,76
8-7-2024	jul-24	Category C	Team B	AT511637	0,97
8-7-2024	jul-24	Category C	Team E	GH760243	0,90
8-7-2024	jul-24	Category C	Team H	GH760556	0,80
8-7-2024	jul-24	Category C	Team F	GH760619	0,84
8-7-2024	jul-24	Category C	Team E	GH760809	0,86
8-7-2024	jul-24	Category C	Team G	GH760854	0,80
8-7-2024	jul-24	Category C	Team B	GH760885	0,78
9-7-2024	jul-24	Category A	Team A	GH761008	0,90
9-7-2024	jul-24	Category B	Team I	AT511552	0,80
9-7-2024	jul-24	Category B	Team D	GH760640	0,85
9-7-2024	jul-24	Category C	Team C	AT510847	0,76
9-7-2024	jul-24	Category C	Team B	AT511637	0,97
9-7-2024	jul-24	Category C	Team E	GH760243	0,90
9-7-2024	jul-24	Category C	Team H	GH760556	0,80
9-7-2024	jul-24	Category C	Team F	GH760619	0,84
9-7-2024	jul-24	Category C	Team E	GH760809	0,86
9-7-2024	jul-24	Category C	Team G	GH760854	0,80
9-7-2024	jul-24	Category C	Team B	GH760885	0,78
10-7-2024	jul-24	Category A	Team A	GH761008	0,90
10-7-2024	jul-24	Category B	Team I	AT511552	0,80
10-7-2024	jul-24	Category B	Team D	GH760640	0,85
10-7-2024	jul-24	Category C	Team C	AT510847	0,76
10-7-2024	jul-24	Category C	Team B	AT511637	0,97
10-7-2024	jul-24	Category C	Team E	GH760243	0,90
10-7-2024	jul-24	Category C	Team H	GH760556	0,80
10-7-2024	jul-24	Category C	Team F	GH760619	0,84
10-7-2024	jul-24	Category C	Team E	GH760809	0,86
10-7-2024	jul-24	Category C	Team G	GH760854	0,80

Desired end result:

[JC2022]

OK, yes this works. 

But now I would like to see the cumulative sum over time. So on the 09/07/2024 date it should be the sum of 08/07/2024 and 09/07/2024 together. For the Categories, Teams and Projects. How can this be done in a measure?

[Anonymous]

Hi @JC2022 

In order to better solve your problem, please open a new case, we recommend a case to solve only one problem, because this can get with good help, and also to give other users a better reference!

Best Regards,

Jayleny

[Anonymous · Accepted solution]

Hi @JC2022 

All you need to do is put the corresponding fields into the matrix.

Result:

Best Regards,

Jayleny

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