learningexcel2019
New Member
- Joined
- May 8, 2020
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi,
I want to filter data between two date fields in a pivot table. For example, i have launch dates of a particular software code. Start Date is the date when coders started working on the code and end date is when it was released. And start date is in the format 01-29-2019 and end date was 05-12-2019. Now i want to create a slicer in the pivot only with months which on selecting will show me the codes which were worked upon on that month, for example if i select April-2019 in slicer, i would see one record with start date as 01-29-2019 and end date as 05-12-2019.
thanks in advance to all!!!!
I want to filter data between two date fields in a pivot table. For example, i have launch dates of a particular software code. Start Date is the date when coders started working on the code and end date is when it was released. And start date is in the format 01-29-2019 and end date was 05-12-2019. Now i want to create a slicer in the pivot only with months which on selecting will show me the codes which were worked upon on that month, for example if i select April-2019 in slicer, i would see one record with start date as 01-29-2019 and end date as 05-12-2019.
thanks in advance to all!!!!