Forum Discussion

JC2022's avatar
JC2022
Helper III
2 years ago
Solved

Cumulative sum measure

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:

DateMonthYearCategoryTeamProjectHours to do per workday
8-7-2024jul-24Category ATeam AGH7610080,90
8-7-2024jul-24Category BTeam IAT5115520,80
8-7-2024jul-24Category BTeam DGH7606400,85
8-7-2024jul-24Category CTeam CAT5108470,76
8-7-2024jul-24Category CTeam BAT5116370,97
8-7-2024jul-24Category CTeam EGH7602430,90
8-7-2024jul-24Category CTeam HGH7605560,80
8-7-2024jul-24Category CTeam FGH7606190,84
8-7-2024jul-24Category CTeam EGH7608090,86
8-7-2024jul-24Category CTeam GGH7608540,80
8-7-2024jul-24Category CTeam BGH7608850,78
9-7-2024jul-24Category ATeam AGH7610080,90
9-7-2024jul-24Category BTeam IAT5115520,80
9-7-2024jul-24Category BTeam DGH7606400,85
9-7-2024jul-24Category CTeam CAT5108470,76
9-7-2024jul-24Category CTeam BAT5116370,97
9-7-2024jul-24Category CTeam EGH7602430,90
9-7-2024jul-24Category CTeam HGH7605560,80
9-7-2024jul-24Category CTeam FGH7606190,84
9-7-2024jul-24Category CTeam EGH7608090,86
9-7-2024jul-24Category CTeam GGH7608540,80
9-7-2024jul-24Category CTeam BGH7608850,78
10-7-2024jul-24Category ATeam AGH7610080,90
10-7-2024jul-24Category BTeam IAT5115520,80
10-7-2024jul-24Category BTeam DGH7606400,85
10-7-2024jul-24Category CTeam CAT5108470,76
10-7-2024jul-24Category CTeam BAT5116370,97
10-7-2024jul-24Category CTeam EGH7602430,90
10-7-2024jul-24Category CTeam HGH7605560,80
10-7-2024jul-24Category CTeam FGH7606190,84
10-7-2024jul-24Category CTeam EGH7608090,86
10-7-2024jul-24Category CTeam GGH7608540,80

 

Desired end result:

Cumulative Sum
measure
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

  • JC2022's avatar
    JC2022
    Helper III
    2 years ago

    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's avatar
      Anonymous
      Not applicable
      2 years ago

      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