Is it possible to have a user choose a value from a dropdown box outside a pivot table (which matches an existing pivot table field) which places that column into the pivot table rows area?
I have a matrix table with 4 main column headings (ABCD) that i can place into my pivot table rows area - that works well.
However, I have 40 other headings across the top of my data table (EFGHIJK.....) which the Pivot Table shows each as its own field in the field list box - they are all the same type of heading (role positions for example, manager, director, admin etc) underneath each heading in the matrix it displays a Yes or No value in rows that relate to that row topic/name.
I need to return all rows where under a given selected column (position) there is a Yes present in the cell.
My table that I am running a pivot table from basically has both row headings and column headings and I cant figure out how to generate a simple dropdown box outside the pivot table (at the top for example) that would put that field into the pivot table.
Note: a user could just scroll down the long field list window and tick their position name and then filter for Yes - but I'm trying to make it simpler.
Any advice is appreciated, can what I'm asking actually be done?
I have a matrix table with 4 main column headings (ABCD) that i can place into my pivot table rows area - that works well.
However, I have 40 other headings across the top of my data table (EFGHIJK.....) which the Pivot Table shows each as its own field in the field list box - they are all the same type of heading (role positions for example, manager, director, admin etc) underneath each heading in the matrix it displays a Yes or No value in rows that relate to that row topic/name.
I need to return all rows where under a given selected column (position) there is a Yes present in the cell.
My table that I am running a pivot table from basically has both row headings and column headings and I cant figure out how to generate a simple dropdown box outside the pivot table (at the top for example) that would put that field into the pivot table.
Note: a user could just scroll down the long field list window and tick their position name and then filter for Yes - but I'm trying to make it simpler.
Any advice is appreciated, can what I'm asking actually be done?
