Interactive Pivot Table - Sort by DATE RANGE?

tangojuliet

New Member
Joined
Mar 21, 2023
Messages
1
Office Version
  1. 2019
Platform
  1. Windows
We are trying to make an interactive dashboard that can give us all data for accounts that have expiring contracts within a specific date range. It has to be easy to use for our employees that rarely use Excel, or a PC at that, will be able to interact with this sheet and get the information they are looking for.

The end goal is to build a pivot table that only shows the customers that have contracts that have expired or are expiring in the next 12 months, next 18 months, or any date range that we are looking for... but also provide all of the detail data for this customer. With that we can build out pivot charts showing admins what Branch or Route these customers are tied to that have the expired contracts or filter them by city/state so we can focus our team's effort geographically, etc.

I have seen =Filter used but we are still on Excel 2019. Is there an easier way to do this using pivot tables, slicers, and timelines? I want to SUM all Contract Numbers as well within this pivot table to show total value of the contract that is expired or will be expired. I also want to see the top 100 customers that are not under contract at the top, no matter what branch or route they are in.

Any help would be amazing!! Thank you!
 

Attachments

  • workbooksample.JPG
    workbooksample.JPG
    153.8 KB · Views: 16

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top