Thanks so much Tushar. It works! Appreciate it very much.
Just a question, would I be able to sum up the total headcount under "Others" and reflect as a chart in the same case?
I managed to get the rest using text labels, but not for "Others". If I 'force' the labels to be shown, it does not aggregate all the numbers under "Others".
You can also see from the screenshot that they are merely "grouped" together as many small bars instead of being grouped as 1 single bar.
Is there a way I could group all as a single bar, and aggregate and reflect the total as a single number too?
Thanks Tushar. The grouping is gone. But should I insert a filter now, I realized that the calculated field does not "create" a nationality on its own when the particular nationality is >0.01.
Calculated Field to sum up all FTE (i.e. no. of headcount)
Then I created the set.
Set named as Nationality > 1%
Last, I created the calculated field to determine if they should be a nationality on its own, or grouped under "Others".
The output is as below screenshot, without any filter. This worked very well. However, if I add in a filter to zoom into foreigners, I believe it does not create a "dynamic" "Others" list.
This screenshot below is seen when I included a filter "Job Family". Under the "Others" category, there are UK, Taiwan, Hong Kong etc whose percentages are more than 1% (i.e. 0.01), however, they remain in the "Others" grouping.
Will I be able to refresh the calculated field with each filter option?
Try adding your filters to context. If it doesn't work, I'll have to look into your workbook.
Ah, this works perfectly now! Thanks so much Tushar, truly appreciate your patience and detailed explanation!