2 Replies Latest reply on Apr 20, 2018 11:39 AM by Mark Fisker

    Multiple Calculated Columns, Based On Date Filter

    Mark Fisker

      To whom this may concern,

       

      I am trying to add two columns to my workbook:

       

      1 column that calculates the total of each row.

      1 column that calculates (and shows) the rank of each person.

       

      I want to do all of this without removing the "Average" Column.

      I also want said calculations to be based off the "Date Time" filter, aka whenever I change the filter, the calculation only happens for that period of time. Anyone know how to do this? Please see picture below!

      Screen Shot 2018-04-09 at 1.55.30 PM.png

       

       

      Thank You and Best Regards,

      Mark