I have created a pivot table and one of the columns of this table is the column " Processname". In this column there are 8 values which I want to see with the results. But by clicking on one of these 8 items the table "rolls up" to 1 value (the selected item), and all other values will not be displayed. Is it possible (and what has to be done) to click on one of the items and all the other values are still displayed??
One way around not using set analysis to clear the user selections is to add a 'clear all upon sheet activation feature'. This worked for me as the other selections were in different sheets.
