i have 3 category A,B,C like the Picture. When i want to show the percentage of each category, i have to do so
Select all the category ==> right click on Marklabel ==> choose Always Shows.
However, i have a Countryfilter with more than 200 countries. Therefore it waste my time to filter each country and then manual choose Always show. For each Country, i have to do this Job once.
Is there any way that enable me to show the percentage of category A,B, C for all countries automatically ?
When you click Always Show, did you checked "Allow labels to overlap other marks". Without seeing a sample workbook, its a little hard to see what you have done.
Hope this helps