1 Reply Latest reply on Jul 1, 2018 3:03 PM by Aaron Sheldon

    Getting previous month data

    sundeep k

      Hi All,

       

         in one sheet i need to show particular selected month details and in another sheet i need to show up to that month details. That means in one sheet i select "march"it will show march details.in another sheet its need to show " jan,feb,mar" details.

        • 1. Re: Getting previous month data
          Aaron Sheldon

          The most expedient way to accomplish this is to create a dashboard with three worksheets, one for the current month, one for the previous month, and one for two months prior. You can then use a filter action driven by the current month to appropriately filter the other two worksheets. It is a bit of a kludge but it gets the job done.