1
1
I'm creating an excel sheet using slicers to populate a particular set of questions for scoping projects in IT.
Is there a way to make the data show up in a specific order (generally the order in which the questions would need to be asked)? Right now, they show up when the correct slicer is selected, but they are jumbled. If I drag them to the appropriate order and then select another slicer, the order changes. Will I need one sheet per set of questions to have my pivot table reference to keep them in a certain order?