Forum Discussion

drrai66's avatar
drrai66
Resolver I
8 years ago
Solved

Running SUM (LINE CHART)- Help Please

Hi Experts,

How I can Create a Running SUM LINE Chart with Week Number on X AXIS and Value on Y AXIS with Following Data. I Need a Formula which I can apply to my Similar Big Data set. 

Thanks in Advance

Deepak

WEEK NumberValue
1174
2294
3118
4222
5399
6126
7110
8164
969
10131
11262
12149
13337
14188
15315

 

Need Help

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    What about a measure like (just replace the table name):

    Running Sum = VAR WeekNum = MAX('YourTable'[WEEK Number])
RETURN

Calculate(
	SUM('YourTable'[Value]),
	ALL('YourTable'),
	'YourTable'[WEEK Number] <= WeekNum
)

     

     

    EDIT:  Now just put this on a Line graph with this measure as the value, and week number as the Axis. 

    • drrai66's avatar
      drrai66
      Resolver I
      8 years ago

      Hi Ashish,

      Actually, I could not access your Solution. Can you provide the formula. As you can see in the following view, I have the weekly values per week in Line graph, so now I want to accumulate them  the way you showed me in previous reply. so that values get added up and I get an Increasing Trend.  I have got these values by COUNTING and not SUMMING. I have to do COUNTING to get these values per week and then do a Running sum of them.

      Thanks for Help again

      Deepak

      This is what I have

      But I need above chart to be like this which I have in Tableau