Forum Discussion
FredDF
Sep 05, 2023Copper Contributor
[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...
- 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.
Riny_van_Eekelen
Sep 06, 2023Platinum Contributor
FredDF but you need to refresh the bigger pt.
FredDF
Sep 06, 2023Copper Contributor
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.
- Riny_van_EekelenSep 07, 2023Platinum Contributor
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.