1 Reply Latest reply on Apr 4, 2016 10:40 AM by Joe Oppelt Branched from an earlier discussion.

    cumulative sum question

    koushik.neelakantha

      Hello,

       

      I have two columns. One is DAY_NUM and other is Sales(Cumulative) measure.

       

      Day_num has Days till 23 like D1,D2,D3......D23. But my cumulative sales are present till Day 21.

       

      I need to show sales till Day 1 to Day 21 in addition with Day 22 and Day 23 sales as zero/null in a BAR CHART.

       

      When I try to drag Day_num and sales, till Day 21 im getting exact values but for Day 22 and Day 23, my Day 21 values are getting displayed. Don't know the Issue.

       

      Regards,

      Koushik