Forum Discussion
Filtering in Pivot
Hello! I have created a Pivot table, where I need filtering. Problem - if field is moved to Filtering section it is automatically removed from Rows section. How to create Filtering without disruptin...
SergeiBaklan Thank you for answer. Unfortunately slicer will work if there are just few clients...in my company we have hundreds 😞 User will be forced to scroll down in order to find proper one.
I see, when helper column. By the way, you could use "nested" slicers, e.g. put on top slicer with groups or simply with first letter in name (alphabet), but that also requires helper columns, preferably in data model.
SergeiBaklan I think I finally understood your advice. It is actually quite good. Better than nothing 🙂 Thanks
Sorry, I missed your previous post. Yes, something like this.
SergeiBaklan thank you for recommendation...could you please share example, how to do it?