Need count of cancelled projects of same client

[chitti5]

Hello All, I want to know the number of projects that got cancelled with Same Client Name and client state for the last 3 months and 12 months from the date it got cancelled and when I drill through it should be able to show the complete details of each project that showed the count.

 FYI - I have 120+ projects that got cancelled from 2022. My table also includes Active projects. This is just a sample data with just 17 cancelled projects and 1 active project for your reference.

Project ID	Project Cancelled date	Client Name	Client State	Status
1	Friday, February 23, 2024	India	Hyderabad	Cancelled
2	Friday, February 23, 2024	India	Bengaluru	Cancelled
3	Friday, April 5, 2024	India	Hyderabad	Cancelled
4	Friday, April 14, 2023	India	Hyderabad	Cancelled
5	Friday, March 22, 2024	India	Hyderabad	Cancelled
6	Friday, April 1, 2022	India	Bengaluru	Cancelled
7	Friday, August 25, 2023	India	Bengaluru	Cancelled
8	Friday, August 25, 2023	India	Hyderabad	Cancelled
9	Friday, December 15, 2023	USA	Atlanta	Cancelled
10	Monday, April 8, 2024	USA	Virgina	Active
11	Friday, April 1, 2022	USA	Virginia	Cancelled
12	Friday, December 15, 2023	USA	Atlanta	Cancelled
13	Friday, April 14, 2023	India	Hyderabad	Cancelled
14	Friday, August 1, 2022	India	Hyderabad	Cancelled
15	Friday, December 1, 2022	India	Hyderabad	Cancelled
16	Friday, April 1, 2022	India	Bengaluru	Cancelled
17	Friday, April 14, 2023	India	Bengaluru	Cancelled
18	Friday, December 22, 2023	India	Hyderabad	Cancelled

Thanks in advance!

[Ashish_Mathur]

Hi,

Based on the data that you have shared, show the expected result very clearly.