I have a pivot table that is utilizing a field for row labels based off the following formula: TEXT(INT([@[DATE_TIME]]-WEEKDAY([@[DATE_TIME]])+1),"yyyy-mm-dd")
This formula removes the time stamp from my date field. However, when trying to select certain dates from within the filter drop-down, it's showing both the date/time and dates from the originating table column with the formula. How to I force the pivot table to read from the formula result?
Example of row label filter:
12/31/2017 23:45
12/31/2017 23:30
12/31/2017 23:15
12/31/2017
12/31/2017 23:00
12/31/2017 22:45
I only want the date of 12/31/2017 without the time!
This formula removes the time stamp from my date field. However, when trying to select certain dates from within the filter drop-down, it's showing both the date/time and dates from the originating table column with the formula. How to I force the pivot table to read from the formula result?
Example of row label filter:
12/31/2017 23:45
12/31/2017 23:30
12/31/2017 23:15
12/31/2017
12/31/2017 23:00
12/31/2017 22:45
I only want the date of 12/31/2017 without the time!