2 Replies Latest reply on Jun 9, 2015 9:44 PM by Greg Barnes

    Calculations for monthly graph view of data

    Greg Barnes

      The attached workbook has two views.


      View 1

      I would like to select one month and view the data for the selected month. However if I want view the data for the selected month I also need to select the previous month for the calculations to work.



      View 2:

      This view has a similar issue to View 1. The first month does not have any data however it needs to be there for calculation purposes.


      Is there another method I can use to achieve this?