Forum Discussion

sdukes_88's avatar
sdukes_88
Frequent Visitor
9 years ago

Cumulative Line Chart Help

Hi,   I need a cumulative line chart but am stuck.   I have month along the bottom of the chart and then it needs to do a sum of funding but it has to sum whatever is in RateBand and be able to f...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi sdukes_88,

I make a test using the following sample data.


Firstly, add an index column in your current table.

Secondly, add a new column using  the following formula.

Cumulative = Calculate ( Sum ( Table4[Funding]), CalculateTable ( Filter ( AllExcept ( Table4, Table4[RateBand] ), Table4[Index]<= Max ( Table4[Index] ) ) ) )



Thirdly, create line chart as follows.


Thanks,
Lydia Zhang

sdukes_88's avatar
sdukes_88
Frequent Visitor
9 years ago

Hi Lydia,

 

Thanks for this and apologies for delay in my response.

 

I'll give this a try, but worried my data won't work with the index as there are also multiple sites (i.e. Site 1 - Site 7).

 

Thanks

Simon