Find average in drill down

[michael_andrews]

Hi, I'd like to find the average of these items I have drilled down. If you look at this data

I want to find the percentages (even though the column name is average score) here is what i have

//Count ItemID gets me 318

COUNT(ItemID) / COUNT({<ItemName = {"=ItemName"}>} ItemID)

Basically, I need to count all items that have the same parent item name

[sunny_talwar]

May be like this

Count(ItemID)/Count(TOTAL <ItemName> ItemID)

[sunny_talwar · Accepted solution]

or this if you want the percentage to stay intact if you make a selection in ItemResponse

Count(ItemID)/Count(TOTAL <ItemName> {<ItemResponse>} ItemID)

[michael_andrews]

You are the man. Helping me hit a deadline in an hour. Thanks!