How to aggregate data across a dimension

[#1]

I have two dimensions:  class & category.

I want to create a stacked bar chart that shows the % distribution of category within each class.  I am able to create a stacked chart of the raw counts  of ids for each category within class, but can't figure out how to get the total count of ids within class.  I have tried

count(aggr(id),category) but that didn't work.  Any suggestions?

[Clever_Anjos · Accepted solution]

Check if fits your needs

[#3]

Thanks!

[nizamsha]

Try this one

count(Total <ID> Category)