Forum Discussion
Solved
[SOLVED] Peculiar filtering in a pivot table I can solve
Hello, Here is a simplified example of my problem (see sample in attachment). I have several tables. Each one contains data for one month. In the screenshot, the table (on the left) stands for the...
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.
I'm not sure what the issue is, does the slicer not do what you need?
The slicer filters the months (only February column will be shown). That’s not what I need. I want to filter the ids according to months. Show only ids that are present in the given month but show also their perfs for the other months if there are. The screenshot shows what I want to accomplish. I don’t know how I can be clearer.
FredDF Perhaps the attached file can help you on your way. I've added two helper columns and an extra pivot table (hidden behind the slicer).
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.
