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
Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Cool Dude,

 

If u remove the Legend from the line chart u can get the Total , I mean sum of Value which u seen in the above bar chart.

 

 

  • sdukes_88's avatar
    sdukes_88
    Frequent Visitor
    9 years ago

    Sorry I don't think I was very clear. I mean I need the cumulative total running across the months.

     

    So in the line chart, Aug+Sep+Oct etc

     

    So if Aug is 20,000 and September is 300,000 the point at September for the line chart should be 320,000 etc 

    • Baskar's avatar
      Baskar
      Resident Rockstar
      9 years ago

      Ooh Cool,

       

      Create new measure for this,

       

       

       

      Running Count1 = CALCULATE(COUNTA('Date Master'[MonthInCalendar]),FILTER(ALLSELECTED('Date Master'[Date]), 'Date Master'[Date] <= MAX('Date Master'[Date])))

       

       

       

      let me know if any help.

       

       

       

       

       

       

      • sdukes_88's avatar
        sdukes_88
        Frequent Visitor
        9 years ago

        Thanks for this - my only problem is that Month is a text field i.e. 01-Aug, 02-Sep etc so it doesn't seem to like this.

         

        If it helps I have 'Period' which is numeric?