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
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