Please find my solution attached based on my experience.
Below is the step by step
1st, create a table of total count for each group as provided
2nd, left join this provided count to your data by using the group as key
3rd, create calculation field for utilisation
Hope this helps
Book21_v10.2.twbx 17.9 KB
Thanks for the quick response. I had considered that approach initially but was advised against because of performance issues. My "group" is actually a collection of 18 different attributes that I would need to perform the join/merge on. I never actually tested this out (although I am trying to this morning) on our servers but I was lead to believe that this would be particularly troublesome for Tableau. Does anyone have experience performing this kind of join?
Assuming that the above approach does in fact have a significant decrease to performance, I would be curious if anyone else has any other approaches to this problem that wouldn't involve joining two datasets.