How to create percentage in total

[liu_weiwei]

Hi all,

There is a question related to create percentage in total in QS, kindly seek your urgent help.

As the attached, can you please help on how to add calculation field to present the population% (for example, the first row of population is 1000, the second row is 2000, total is 3000, how to present with a column named population%, to present as row1 is 1000/3000100%, row2 is 2000/3000100%, total is 100%)

The population here is a calculated field (max of datasize), and under AU, there are many subrows.

And, I am in Amazon but not aware of how to contact QS team for support directly, if there is any chance we can have a call with QS team via Chime within Amazon?

Thanks for your help!

[Deep]

Hello Liu,

May be please try to refer the old post below.

percentOfTotal - Amazon QuickSight

Calculate percent of total by row

Hello team! I have a data source that has data by marketplace (country), and I am trying to get the representativity % of a field (value) based on the group row, not the column. So for instance, I have marketplaces 4 and 5. Instead of getting a percent of total for them that would sum 100% altgother, I need that within marketplace 4, I have a SUM of 100% and within marketplace , a sum of another 100%, meaning that I need the percent of total to be based on whatever I put as a row (markeplace, i…

Hope this helps in getting some idea to achieve what you are looking for.

Cheers,
Deep

[liu_weiwei]

Hi @Deep

Thanks a lot for your reply!

I reviewed the attached file and tried as below:

population% = percentOfTotal({Population},{Unique Identifier_Calculation})

Below are the rows and columns that I have added:

what I want to present is :

Could you please kindly let me know how to add formula for the population in QS to present?

Please not, the population is a calculated field, which is "population=max(data_size)

Thanks!

[liu_weiwei]

Hi, @Deep

Could you please help on this?

Thanks

[liu_weiwei]

@Deep

Kindly seek help from anyone in QS team, thanks!

[Brett]

Hi @liu_weiwei,
It’s been awhile since last communication took place on this thread so checking in to see if you’re still encountering the same issues?
What if you added a second ‘population’ field to your visual and then run a table calculation for percent of total?

Let us know if this would work for your case, or if you’ve found a different work around in the time since that worked. If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

[Brett]

Hi @liu_weiwei,
Since we have not heard back, I will 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!