I have 3 date fields, Submitted Date, Approval Date, and Terminated Date. I have 3 columns in my table:
Count (Submitted Date)
Count (Approval Date)
Count (Terminated Date)
I would like to know if it is possible to have 1 date field that, I can filter by, that would affect all 3.
For example if I choose 01/01/2016 on my new field it would filter the 3 dates for my table. I provided a screenshot of my table and the Date fields.
The current behavior is that if I change my Approval Date to 01/01/2016 it filters my Total Approved column perfectly but not the others.