1 Reply Latest reply on Feb 4, 2019 11:14 AM by Scott Hoffman

    TTD Comparison

    Pauline Tisseyre

      Hi Everyone,

       

      I'm attaching the most recent workbook I'm working on. I still haven't figured out how I can add a column that shows Total Players YTD from 2018.

      Right now my view is filter with 2019 data only. But I would like to remove that filter and be able to have:

      * Total Players YTD (With 2019 data)

      * Total Players YTD (With 2018 data).

       

      Any help would be greatly appreciated!

       

      Thanks!

      Pauline

        • 1. Re: TTD Comparison
          Scott Hoffman

          Pauline,

           

          I attached a workbook that has 2018 and 2019 separated by columns but the way the sheet is laid out there are different records for each school/year.  If you would like this on one line I would suggest grouping by location or using a fixed LOD with Location/Year depending on what you want the results to look like.

           

          Let me know if you have any questions.

           

          Thanks,

          Scott