Need to ungroup bar chart

[tmumaw]

Hi all,

I need to ungroup this bar chart, however it won't let me.  Any ideas?  I'm using the same measure only separating Sales and Costs using set analysis.

Thanks

[neelamsaroha157]

Did you try to change the style of the bar -

[tmumaw]

Yep

[neelamsaroha157]

Just to confirm, you want separate bar for cost and Sales, right?

Can you share sample qvw?

[tmumaw]

Sort of hard to share QVW very large.  It only has 2 expressions, Sum({<Sales_Cost = {C}>} Actual) for costs and Sum({<Sales_Cost = {S}>} Actual) for sales

[neelamsaroha157]

tried to mimic your chart with some random data - Let me know if its helpful.

[tmumaw]

I think I may have found it.  In your sample can you breakout a separate column for Year and Month, then use both of them as dimensions?  Thanks.

[tmumaw]

I created a dimension which is YYYY_MM and deleted FISYR and MTH as dimension.  Then used YYYY_MMM and it worked.  Thanks for your help.