How to calculate percentage of specific field in QuickSight

Question & Answer
,
1

Hi,

I am having following Data

image
image295×181 2.46 KB

I had a Company Id filter. I want to calculate the percentage of sales for every Company id.

Total No of of Sales ID is 70.

No of Sales Id for Company id 1 is 10.
if the user selects Company id 1. Then we have to show
No of Sales for Company Id 1 (10)/ Total No of Sales Id (70) : 10/70 = 14.29%

No of Sales Id for Company id 2 is 12.
if the user selects Company id 2. Then we have to show
No of Sales for Company Id 2 (12)/ Total No of Sales Id (70) : 12/70 = 17.14%

No of Sales Id for Company id 3 is 14.
if the user selects Company id 3. Then we have to show
No of Sales for Company Id 3 (14)/ Total No of Sales Id (70) : 14/70 = 20.00%

No of Sales Id for Company id 4 is 16.
if the user selects Company id 4. Then we have to show
No of Sales for Company Id 4 (16)/ Total No of Sales Id (70) : 16/70 = 22.86%

No of Sales Id for Company id 5 is 16.
if the user selects Company id 5. Then we have to show
No of Sales for Company Id 5 (18)/ Total No of Sales Id (70) : 18/70 = 25.71%

we want to show these percentage in KPI. Could you please let me know how this can be done?

Thanks,
Satya

2

Hi @SatyaPaleti

To get Total Sales for total company you can use level aware calculations. Please refer the article below where you should find examples to create the required calculated field.

Regards,
Giri

3

Hi @SatyaPaleti,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @SatyaPaleti,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!