Forum Discussion
[SOLVED] Peculiar filtering in a pivot table I can solve
Riny_van_Eekelen Actually, I found an elegant solution using measure. Check it out https://www.excelforum.com/excel-charting-and-pivots/1411536-peculiar-filtering-in-a-pivot-table-i-can-solve.html.
Thanks but selecting the month in the slicer doesn’t filter anything the pivot table. It only filter the hidden pivot table and change the values in the source table. But it’s a start. I’ve updated my thread with an excel file as attachment.
FredDF but you need to refresh the bigger pt.
Riny_van_Eekelen Actually, I found an elegant solution using measure. Check it out https://www.excelforum.com/excel-charting-and-pivots/1411536-peculiar-filtering-in-a-pivot-table-i-can-solve.html.
FredDF Good for you!! Not really interested in the solution,
But, it's not good practice to cross post your problem in multiple fora, like here, Answers, ExcelForum (and perhaps others as well) and not telling us about it UP FRONT.