Not certain I fully understand the goal but see if this works
this is the aggregated avg at the customer/cat level
this will put a label on the values
then creating the vis uses the % total table calculation on a countd of the order ids's
it returns 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.
stacked bars % total.twbx 2.4 MB
Thanks Jim! Exactly what I was trying to do. I was trying to fix the LOD on customer, but I see now that I needed to include the other dimensions as well. Still learning how the LODs work....
Keep working at them - powerful tool but take some practice
Glad to help out