I have a stripped down data source for debugging purposes
I only have 4 rows of data for test purposes. The dates are formatted as dates
When I create the pivot table the dates become my column values.
When I select the first date in the pivot table the Group By Field menu option is grayed out.
I tried setting a tabular format but didn't work.
I only have 4 rows of data for test purposes. The dates are formatted as dates
When I create the pivot table the dates become my column values.
When I select the first date in the pivot table the Group By Field menu option is grayed out.
I tried setting a tabular format but didn't work.