4 Replies Latest reply on Nov 14, 2018 10:01 AM by Kevin Das

    Running Total On Dual Axis - How can I show data for all months for one measure (budget) but not all months for another measure (sales)

    Kevin Das



      I need to create two charts showing sales vs budget. One chart will show monthly sales vs monthly budget, by month. This is simple enough to create:


      Pic 1.png


      The second chart needs to look almost identical but show running totals.


      I only want to show running total for sales up to the latest month with sales (October) but the running total for budget should show all months.


      I cannot see how to remove the running totals of sales for months after October without also removing the running total for budget:

      Pic 2.png


      I have attached a simplified example workbook hoping someone can help - I am sure I am missing something very simple!!


      Many thanks for any help