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!




        • 1. Re: TTD Comparison
          Scott Hoffman



          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.