Create visual for distinct count combined with summed data

[kdbbi]

Hi all,

I have been searching the internet for ages, but I can't find the exact solution I need. Hopefully one of you can help me out.

I have a challenge with a dashboard I am building with different data sources. 

One source gives me data per record per date with unique ID's

One source gives me data per bulk per date without unique ID's

I want to make a stacked visual where I show the summed unique ID's and the bulk together in a visual. Currently I have a visual with only the unique ID's (see below screenshot). My goal is to have a custom column as marked bold. 

Can anybody help?

Date	User Unique ID	Category	Bulk count data	Distinct count per day	Cars and Trains
1-1-2023	ABC	Train		1
1-1-2023	ABC	Train
1-1-2023	DEF	Train		1
1-1-2023		Cars	250
1-1-2023		Cars			250
1-1-2023		Train			2
2-1-2023	ABC	Train		1
2-1-2023	DEF	Train		1
2-1-2023	DEF	Train
2-1-2023		Cars	320
2-1-2023		Cars			320
2-1-2023		Train			2

[BIswajit_Das]

Hello @kdbbi 
Can you share the demo data for better understanding
Thanks & Regards...