Forum Discussion

Annemie's avatar
Annemie
Frequent Visitor
7 years ago

Cumulative Values By Month/week and graph

Hello, I got the question to create a table like this : they want a weeky cumulative view

 

 

I got as far as this : the getting it weeky, I maybe, posibly can figure out, but how do you cumulate the data...

 

Next they expect a chart like this one

 

 

Is there someone who can help me how I could get this kind of data view ?

 

Thanks a lot in advance,

 

Annemie

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    7 years ago

    I would first check out the Running Total Quick Measure. If you create a column using WEEKNUM and base the running total on that, should be what you want.