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?