I'm hoping this is just a setting I'm overlooking. I have a spreadsheet where I'm pulling in data from a query. I have a start and end date parameter. If I extend the date range to span multiple years, I can group the pivot table on years, quarters and months. However, if I change my date range to a year or less, I lose the grouping altogether. I'd like to maintain that grouping if possible regardless of the date range.
For example, let's say I run the query for 3/27/20 thru 3/31/20. I'd like the pivot table to show a year grouping of 2020, a quarter grouping of 1 and a month grouping of March. That way, no matter what my date range, the pivot table will always be grouped by year, quarters and months.
Thanks in advance for any assistance.
For example, let's say I run the query for 3/27/20 thru 3/31/20. I'd like the pivot table to show a year grouping of 2020, a quarter grouping of 1 and a month grouping of March. That way, no matter what my date range, the pivot table will always be grouped by year, quarters and months.
Thanks in advance for any assistance.