Multiple clustered column chart with monthly breakdown per category.

Hi there,

I've viewed few posts but didn't find anyting that fitted my example. Wondering if anyone could suggest something for me? 

What I want to achieve is have a column chart with:

X-Axis :  Month & Supplier Name

Y-Axis: Total Purchase Value & Total Supplier Capacity 

Originally I thought, well this is simple enough but supplier capacity is not planned out for rolling months. It a value that is stored per supplier on the system and can be changed at any time and there is no date against it so when I try to put it into report it's not right as it's being summarized for all suppliers. 

What I have so far:

Supplier name on X-Axis

Total Purchase Value vs Supplier Capacity

When I add in timeline to it:

I'm using line and clustered column chart and cannot seem to add Supplier Name as Column Series. As you can see this isn't right. Would you suggest using a different measure from app store or creating some fancy calucations to get over this? 

I'm already grateful for any feedback on this. 

Thanks,

K