Search results

Hello, as many know, when you add Slicers to Pivot Tables, apply those Slicer filters, then double-click Pivot Table results to see the underlying data, you get ALL the unfiltered data. The only fix I am aware of is to add rows and add the "old fashioned" Pivot Table filters, then hide those...

Thank you very much Luke. VBA is new to me, but I have people I work with who can help me, if I can't figure it out, but it looks pretty straight-forward. And I can open this new attachment, its not blocked :)

Luke, I just sent you a private message, I cannot open your file, company security blocks it.

I own the report, so I can sort it any way it needs to be.

Yes, Luke, exactly!

Picture a table: Column A is people's names, with some duplication. Column B is the date they started a project, no blanks. Column C is the date they finished a project, no blanks. They log a new start and end date every time they work on their project. I want to calculate the total days each...

I have four Pivots tables that all use the same data (the data is on a worksheet in the same file as the pivots). Is it possible to have ONE set of filters control the behavior of all four pivots simultaneously?