Forum Discussion
Pivot table manual row label filter no longer allows expand/collapse hierarchy
If in your data model Field1 and Field2 are in hierarchy and hierarchy is added to rows in PivotTable, it shall work as "before" in your case
If to add to PivotTavle fields themselves, not hierarchy, behavior will be as what you have "now"
I am certainly not the most suitable to give you an answer.
But if I can recommend, It can help us all if you upload an Excel file (without sensitive data), no picture.
Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases.
You could get a precise solution much faster with a file (w/out sensitive data).
This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
* Knowledge of Excel version and the operating system are a must if you want to get a reasonable solution (Example: office version e.g. 2016 or 2019 or 365 web or 365 pro, etc) and your operating system (e.g. Win10 (2004), Win 10 (1903), Mac, etc.).
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)