Forum Discussion

FredDF's avatar
FredDF
Copper Contributor
Sep 05, 2023
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...
excel
office 365
  • FredDF's avatar
    FredDF
    Sep 06, 2023

    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's avatar
FredDF
Copper Contributor
Sep 06, 2023
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.
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Sep 06, 2023

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).

 

  • FredDF's avatar
    FredDF
    Copper Contributor
    Sep 06, 2023

    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.

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Sep 06, 2023

      FredDF but you need to refresh the bigger pt. 

      • FredDF's avatar
        FredDF
        Copper Contributor
        Sep 06, 2023

        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.

Resources