Calculated dimensions for a stack bar?

[dafnis14]

Hi,

I have a requirement to create  the below chart:

the upper line - should represent only selected agents.

The lower line - all the agents.

each bar represents sales amount of a specific product type.

I'm not sure how this could be done. 

Should I use two separate charts or can one be achieved?

Would appreciate some guidelines..

Thanks!

[dafnis14]

This thread has the answer

Re: Stacked bar chart : Calculated Bars

Thank you Sunny!