How to get a combi chart with 2 dimensions?? Excel can do it... :-(

[#1]

Dear all,

I have a real life case in which I want to combine sales data per product per year with the sales target per year. Nothing special I would say...

See attached Excel file and QVW... I don't think this is possible in QV?!

Maybe I have to set up my data differently?

Please help!

Regards,
Marcel Artz

[swuehl]

If you can create an expression per measure, you can recreate the Excel chart.

See attached.

[#3]

Yes, that would be an option if the number of products wasn't flexible and over 25 products.

Any other options?

Regards,

Marcel

[#4]

Although not as per requirement however you can have a look.

Hope this helps.

Regards

Mhatim

[#5]

Hi Mhatim,

Thank you for the additional information, but as you already said, not quite the complete answer. Thanks for your help!

Regards,
Marcel

[#6]

Hi,

Or you can try this one if you like.

Regards,

Janzen

[#7]

Thanks Janzen,

These are all work-a-rounds for something that is basic functionality in other tools. I'll pass this one on as an idea for development.

Thanks for your help!

Regards,
Marcel