Hi,
I have table queries which are appended into one query. see below
I have a sheet which some fields are taken from above (some not shown here) see below
Columns 1 - 3 are Pivot Table fields
Merged cells in merged column 4 is formula cell - The result of the formula will show text of the Description column in the query above. (it has to be formula because pivot tables don't merge across columns)
Cells in column labelled 5 below the header is a formula - The result of the formula is a vlookup of the query table above based on the date selected in I1.
Using slicers to filter the pivot table, will filter by column 1 and/or 2. The formulas in 4 and 5 will pull the data through.
But ideally I wanted to filter the table by Date, but I don't know how to make this happen. I tried making a separate table to connect the slicer to two different tables, but couldn't make that possible.
The layout of the query is as the table it is pulling data from, so the query layout can change but not the source data.
Trying to work out if possible to filter by date in a slicer which will filter the pivot table (columns 1-3) so when the data in column 5 will be no blank spaces in rows which are not needed.
I know people can use the drop down filter in the table, but it would be nice to connect it all so they don't necessarily have to use the drop down filter, otherwise it is pointless having the slicers.
Any ideas would be appreciated.
I have table queries which are appended into one query. see below
I have a sheet which some fields are taken from above (some not shown here) see below
Columns 1 - 3 are Pivot Table fields
Merged cells in merged column 4 is formula cell - The result of the formula will show text of the Description column in the query above. (it has to be formula because pivot tables don't merge across columns)
Cells in column labelled 5 below the header is a formula - The result of the formula is a vlookup of the query table above based on the date selected in I1.
Using slicers to filter the pivot table, will filter by column 1 and/or 2. The formulas in 4 and 5 will pull the data through.
But ideally I wanted to filter the table by Date, but I don't know how to make this happen. I tried making a separate table to connect the slicer to two different tables, but couldn't make that possible.
The layout of the query is as the table it is pulling data from, so the query layout can change but not the source data.
Trying to work out if possible to filter by date in a slicer which will filter the pivot table (columns 1-3) so when the data in column 5 will be no blank spaces in rows which are not needed.
I know people can use the drop down filter in the table, but it would be nice to connect it all so they don't necessarily have to use the drop down filter, otherwise it is pointless having the slicers.
Any ideas would be appreciated.
