1 Reply Latest reply on Mar 30, 2018 3:52 PM by Cathy Bridges

    Previous and Current time period crosstab

    Scott Strool

      Can something like this be created as a single worksheet?

       

      If not, what alternatives are available to display similar information?

       

      Screen Shot 2018-03-28 at 3.12.25 PM.jpg

        • 1. Re: Previous and Current time period crosstab
          Cathy Bridges

          I might be more inclined to put it on a single dashboard rather than a single worksheet.

           

          I think you'd need at least 6 calculations in order to divide your dates into those buckets.

           

          Something along these lines:

          IF DATEDIFF('month',[Month Date],[MaxMonth])<=11

          then

          'CY'

          elseIF DATEDIFF('month',[Month Date],[MaxMonth])>11

          and DATEDIFF('month',[Month Date],[MaxMonth])<=23

          THEN 'PY'

          ELSE NULL END

           

          But you'd need to figure out the datediff you need for each bucket.