one series multiple things in colum =n combination chart(design studio)

[Former Member]

Searched Blogs before posting but not full filled my requirement

https://archive.sap.com/discussions/thread/3459609

https://archive.sap.com/discussions/thread/3571427

HI Experts,

I have a Strange requirement where i need to show line and bar for same data series in column combination chart

If you see above chart black bar is MTD and dotted line is YTD which is coming as single series from backend .because it is a structure.please find the bex image

I am using colum combination for this chart

any Suggestions will really helpful for this strange requirement:(

Initial view of design studio

Thanks,

Varun

[former_member265529]

Hi Varun,

Can you change the query structure?

Because your requirement have some restrictions to implement in design studio. like you need to place one chart over other. So you can't have tooltip or X-axis label in chart.

But you can create YTD and MTD as measures in query and it can be easily mapped to chart by data selection.

Thanks,

Poovarasan