Please, are there any other experts willing to help?
All is working except when I select another cell. is there a second approach I could take?
I notice that all dimensions are being selected when I click the expression, however when I click an adjacent cell and that cell shares the same value in one or more dimensions, it removes the filter. I need a way of applying every dimension value, every time a cell click event occurs.
I should add that my pivot table is using set analysis expressions so the table doesn't collapse when a cell is selected.