I have a pivot table with a status category as rows and a grouped date in the columns.
I have implemented a navigation action to another sheet with the raw data which is filtered using the parameters from the selected row/column of the cell. This action works as expected, except in the case of the total/subtotal column. Ideally this would navigate to the raw data sheet and show the data for the appropriate status and the date over the last quarter/year/all time. It appears that the navigation works correctly for the total row (at the bottom of the table) so I assume this issue relates to the subtotal/total column not registering the appropriate date range to which it is linked.
I have looked around on various forums using different descriptions and not come across anyone else asking about this particular issue. Has anyone else experienced/resolved this issue with their own analyses?