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

      Hi,

       

      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

       

      Kev