Each sales person is a member of a sales group but currently the only way I know how to show data for both is in two separate charts. Is there any way I can show both sales group and sales person in the one chart?
I guess that will solve your issue as per my understanding. You are trying to make a 3 dimensional chart i.e one axis for sales group,one axis for sales person & one for sales. Most of the charts/visual you will find are 2 dimensional. I guess matrix is the only visual where you can take 3 things/commodities into consideration. I may be wrong but this is what i have understood from your requirement.