Not very sure what's your expected result. but if you want to compare individual customer with its group, probably you can try
Please let me know if any question
I would like to compare the average in the group to the customer in two different lines in the same diagram
here is one way to do this with sets
it will 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.
Book2_v10.2.twbx 19.7 KB