Pie Chart with calculated dimension for single vs multiple values in a field

[Bhel]

Hello,

I'm trying to create a pie chart that correctly identifies and separates out counts where, for example, a client has more than one type of order for a given time period. Below is a sample data set, and I'd like to have the pie chart group counts of client ID by order type between 'Product', 'Service' and 'Both'. Without any date filter applied, here's what I would hope to get as a result, but would need it to remain responsive to date filters.

Thanks in advance for your assistance!

Orders:
Load * Inline [
Date, Order Type, Client ID

01/01/2022,Product,13
01/01/2022,Service,13
01/02/2022,Service,2
01/02/2022,Product,18
01/02/2022,Service,19
01/03/2022,Product,5
01/05/2022,Product,18
01/07/2022,Service,9
01/12/2022,Product,12
01/12/2022,Service,19
01/13/2022,Product,12
01/14/2022,Product,21
01/21/2022,Product,17
01/22/2022,Service,21
01/23/2022,Service,10
01/23/2022,Service,20
01/23/2022,Service,24
01/24/2022,Product,5
01/26/2022,Product,24
01/26/2022,Service,25
01/27/2022,Product,15
01/27/2022,Product,20
01/28/2022,Product,4
01/28/2022,Product,13
01/30/2022,Service,5
01/31/2022,Service,23
02/02/2022,Product,21
02/04/2022,Product,1
02/04/2022,Product,5
02/04/2022,Product,10
02/06/2022,Product,7
02/09/2022,Product,13
02/12/2022,Service,3
02/16/2022,Product,4
02/16/2022,Service,9
02/23/2022,Product,1
02/23/2022,Service,3
02/23/2022,Service,15
02/23/2022,Service,21
02/24/2022,Product,12
02/25/2022,Service,1
02/28/2022,Product,17
02/28/2022,Service,23
03/03/2022,Service,5
03/05/2022,Product,13
03/07/2022,Service,3
03/10/2022,Service,22
03/14/2022,Service,2
03/14/2022,Service,8
03/14/2022,Product,9
03/14/2022,Product,17
03/15/2022,Service,8
03/16/2022,Service,5
03/19/2022,Product,10
03/19/2022,Service,15
03/22/2022,Service,13
03/24/2022,Service,2
03/24/2022,Service,8
03/25/2022,Product,5
03/25/2022,Service,25
03/26/2022,Product,21
03/27/2022,Product,6
03/27/2022,Service,24
03/28/2022,Product,24
03/30/2022,Service,8

];