Good day Sean.
Without the data set or a sample workbook it's tricky. Can you provide sample data? Is Score column the column 2? Is the score field an aggregate of some kind? If so, what's it an aggregate of?
This really looks doable with level of detail calculations, but saying what they are really depends on the structure of the data you're using.
you are probably using something like this to create you indicator
then you run into trying to use further calcs and an already aggregated field
you could use this lod which will return the same valuees as the one above but they are NOT aggregated and can be used in other calculations
this will determine the % of total based on the count of categories
they return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
sorry one of the attached is in 10.5 the other in 2019.3