Forum Discussion
Pivot Table
Hi everyone, I have an issue with the pivot table. There are filters from slicers and row labels in the table; when I double-click on any category from the table to see the filtered data, Excel fetch...
Try below
- Right‑click > Show Details (creates full dataset).
- Then apply your numeric filter manually on the new sheet. This ensures you see only the relevant clients.