I'm working with the responses of a NPS survey. The responses are essentially ratings from 1-10. I also have a bunch of demographic information (region, BU, user category etc), and rating questions for other elements as well (training, support, UI etc).
I want to create a simple one-page "dashboard" of sorts with slicers that update the NPS score based on the filters selected, and show the results across the other question categories. The NPS score is being calculated outside of the data table because it's a separate calculation based off of the count of different responses.
Is it possible to create a data table of sorts, which have the raw data itself that I can play around with using slicers? Like a pivot table, but with the raw data.
Right now, I have formulas drawing the numbers from the cell references thus using slicers on the table doesn't do anything.
Any help/suggestions/recommendations are more than welcome!
Thank you
