Forum Discussion
Excel Pivot Table & XLOOKUP
GSAInsp I looked at it again and made your workbook more transparent. Hiding columns, colouring cells drastically is something that stresses me out. Sorry. So, when you say "FILTER is my weak point" do you mean that you don't understand how to use the FILTER function or that you don't have the FILTER function?
In case it's the first option, the attached file links the dropdown to a dynamic FILTER range, rather than to the output of a pivot table. Hopefully it works for you.
GSAInsp I looked at it again and made your workbook more transparent. Hiding columns, colouring cells drastically is something that stresses me out. Sorry. So, when you say "FILTER is my weak point" do you mean that you don't understand how to use the FILTER function or that you don't have the FILTER function?
In case it's the first option, the attached file links the dropdown to a dynamic FILTER range, rather than to the output of a pivot table. Hopefully it works for you.
- THAT IS PERFECT... Thank you and I understand the hiding & coloring of fields...
Don't know how to use the "Filter" properly in Excel.