To show % of Distinct count field -percentOfTotal (workaround )

I have a field that should show the % of that field by distinct count.
Is there a workaround for percentOfTotal

I have created one example in below. showing sales by industry and total sales in column 2. In column 3, I am calculating the percentage of sales for each industry. is it what you are looking for?

if yes, you may calculated field by using Level Aware Calculation
Total Sales by Industry: sum(Sales)/sumOver(sum(Sales), [])
image

Level Aware Calculation: Using level-aware calculations in Amazon QuickSight - Amazon QuickSight

2 Likes

This will show the percentage of the sales,

I want to have a percentage of the field that has a distinct count and its percentage.

Did you try using function distinct count over?
You can follow the same calculation logic, instead of using sum, can use distinct count