I'm struggling a bit with displaying my figures as a percentage, and have two questions on this. I'll try to be succinct:
1. In a "Top 5" chart, how can you compute a count as a percentage of that subset? Here's my most recent failed attempt, reading other posts.
count(ID) / (if(aggr(rank(count(ID)),Category)<=5, count(ID)))
2. How do you see your table totals as both a count and percentage? I don't want to add a percentage expression because it is then applied to every dimension.