I have a table that looks like below ID DT Main Category 1 19-08-2022 A 2 20-08-2022 B 3 20-08-2022 A 4 19-08-2022 B 5 20-08-2022 A 6 20-08-2022 B 7 19-08-2022 A 8 20-08-2022 A 9 20-08-2022 A 10 20-08-2022 A I want the output to be like below Main Category DT Count of ID A 19-08-2022 6 A 20-08-2022 6 B 19-08-2022 3 B 20-08-2022 3 I don't want the count of IDs to be split by the column DT. I have tried using the below functions countOver({ID},[{Main Category}]) The code requires me to add the column ID on table and also results in duplicates on visuals. Can someone suggest how can I solve this?

QuickSight : How to display the totals of the category without splitting it by sub totals and not duplicating the rows on the visual

I have a table that looks like below

I want the output to be like below

I don't want the count of IDs to be split by the column DT. I have tried using the below functions

countOver({ID},[{Main Category}])

The code requires me to add the column ID on table and also results in duplicates on visuals. Can someone suggest how can I solve this?