MTD,YTD & its total in a single chart

[#1]

Dear All,

I have a requirement where I need to show MTD & YTD Performance Departmentwise & its TOTAL in a single bar chart.
Please find the enclosed data sheet for reference and provide a solution.
Thanks in Advance,

Regards,

Kumar

[#2]

Hi Kumar,

Please check the attached one.

Regards,

Sajeevan

[#3]

Thanks for your quick response Sajeevan.

Is there any other way of doing this?
Ths issue is that Department names are not fixed & we cant hardcode that.
I am aware that this can be done easily in QV11 but I have to use QV 10 SR3.

Regards,

Kumar

[#4]

Hi Kumar,

Please check the attached one - third graph - Total line may not be possible

Regards,

Sajeevan

[#5]

Sajeevan, I need to show the total as well.  Thanks for your responses.

Just a request if anyone can provide some solution on this.

Regards,

Kumar

[#6]

Hi,

I've attached one application with the chart showing total values also. Please verify it.

Thanks & Regards,

Arun Prasadh.N.

[#7]

Dear Arun,

Thanks for response.
My requirement is slightly different, I need to have two dimensions and expression for MTD,YTD & also sum of (MTD,YTD)

Red Bar is the total of respective MTD & YTD.

Hope u get my requirement.

Thanks,

Kumar

[#8]

Hi kumar,

PFA.