Hello all,
I have a table which I have created a query so to display this information in a Pivot table
I will have other tabs with same layout, which I will combine/append later. Right now the issue is with displaying this information in a pivot table, I cannot filter by date (columns N onwards) to show the P number, because there will be 50 slicers, which is utter pointless.
The end result would be for example filter by 31/01/2025 would only show one column with the P numbers and the relevant document information linked to the filtered date & P numbers
I do not want fifty date columns in the pivot table, because I might as well use the Query sheet, so that would defeat the object of a pivot table which can grow and shrink depending on what date you filter by.
Is there another way of displaying this information without have 1000 rows of formulas which doesn't help in what I am trying to achieve which is a tidy version of the query.
Or is there another way of changing the layout of the query to suit. I did try the column transpose but it didn't work that well either.
I have a table which I have created a query so to display this information in a Pivot table
I will have other tabs with same layout, which I will combine/append later. Right now the issue is with displaying this information in a pivot table, I cannot filter by date (columns N onwards) to show the P number, because there will be 50 slicers, which is utter pointless.
The end result would be for example filter by 31/01/2025 would only show one column with the P numbers and the relevant document information linked to the filtered date & P numbers
I do not want fifty date columns in the pivot table, because I might as well use the Query sheet, so that would defeat the object of a pivot table which can grow and shrink depending on what date you filter by.
Is there another way of displaying this information without have 1000 rows of formulas which doesn't help in what I am trying to achieve which is a tidy version of the query.
Or is there another way of changing the layout of the query to suit. I did try the column transpose but it didn't work that well either.