Creating Excel Sheet using Slicers - Keeping data in specific order

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?

Jonathan Green

Posted 2019-05-21T14:13:05.873

Reputation: 11

No answers