Pivot Table Slicer by Week

[aramis201]

Hello

I have a Pivot table where I would like to filter by week using a slicer to show active projects.

In my raw data table I have three columns: Project Name, Starting Week, Ending Week.

So for Example if:

Project 1 starts at week 1 and ends at week 4.
Project 2 starts at week 3 and ends at week 6.
Project 3 starts at week 4 and ends at week 7.

And I click week 4 in the slicer I should get all three projects since they are all active in week 4 but if I were to filter by week 6 I would get only Project 2 and 3 since project 1 already ended at week 4.

Thanks in advance.

[kev_]

welcome to the forum

please
- attach a workbook with the pivot tables that you currently have (including the base data)
- ADD a sheet showing what you would prefer to see - include filter details etc

thanks

to attach a file click on Reply, the Go Advanced, then look below for Manage Attachments etc
ManageAttachments3.jpg