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...
You may use slicers or add to the source another helper column which duplicates rows field and filter on it. Please check in attached.
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
