5 Replies Latest reply: Sep 8, 2015 12:02 AM by julio césar torres RSS

    last 3 months print records in a pivot table

    julio césar torres

      HELLO

      I need help!

       

       

      I have a table called work scheduled on that table have a date which shows the progress of these works, but dates until 2019 mark

      my table and mark the progress of these current record is 2015, every 15 days made a cut on the progress of the work, so my log table has cut eg

       

       

      01/15/2015

      30/01/2015

      02/01/2015

      15/02/2015

       

       

      up to: 31/08/2015

       

       

      as I can do to show in a pivot table only the last 3 months or 6 cuts last 15 days records progress:

       

       

      for instance:

       

       

      15.06.2015,

      06/30/2015

      15/07/2015

      07/31/2015

      08/15/2015

      08/31/2015

       

      but only consider the records of progress of works and not consider the records until it reaches the scheduled work to date = 2019

       

       

      Thank you