0
While I know its possible for a pivot table to create a date range to showcase values, is it possible to have 3 date ranges? I would like to have 3 columns with date ranges 1. 1/4/19 - 5/25/19 2. 5/26/19 - 12/4/19 3. 12/25/19 - 1/3/2020. Then ideally the values would fall under the corresponding dates
user1119458
Posted 2019-12-08T00:15:26.127
Reputation: 1
In my opinion you need to create Auxiliary column first based on the rule for date in source table. Try to provide the sample file or screenshot of source table here. – Lee – 2019-12-09T08:12:01.763