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...
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 thank you for recommendation...could you please share example, how to do it?