Comparsion of sales in stack bar chart

[Anonymous]

Hi All,

Is it possible to compare sales of 2016 quarters with 2017 quarters in stack bar chart? But 2017 quarters must be always YTD sales.

Today : 27/07/2017

Ex: Q1 2016 - Jan, Feb, Mar of 2016. But Q12017 should be entire sales of 2017 upto today.

same applies for Q2 2016 - Apr, May, Jun of 2016 but Q2 2017 should be entire sales of 2017 upto today. same applies for Q3 and Q4 as well

Is it possible to achieve this? Thanks to advice

Regards,

Krishna

[Anil_Babu_Samineni]

Like this?

[Anonymous]

Yes Anil.

[Anil_Babu_Samineni]

PFA

I would high recommend you to please mark as helpful so then we can link up to you easily from right point. And if your solution got resolved you can closes this thread

[Anonymous]

Anil, with same expressions, when i try with customer Key, produced result is not same as expected. I am attaching another sample data please try and advice. There is time,customer dimensions and facts. As quarter & year, Customer  as dimension, sum of delivery qty as expression.  Current output and Expected out put  also attached as of now unable to achieve YTD for 2017 quarters.

[Anil_Babu_Samineni]

If possible please share QVW to work rather my end

[passionate]

Hi Krishna,

In your sample data as you don't have data in 2017 for other months than july.

How did you get Q1, Q2 values in 2017.

Regards,

Pankaj

[Anonymous]

Hi Pankaj,

You can edit values in sample sheet. no problem.  it is sample data.

[Anonymous]

Hi Anil,

Please find attached QVW file. Thanks to advice. Just to reiterate requirement, Q1, Q2 and Q3 2017 should be YTD while comparing with Q1-Q4 2016. Thanks to advice. Script changes also fine.

Regards,

Krishna

[Anil_Babu_Samineni]

I think you have taken this from Server and developed. I got this error while trying open your application

[Anonymous]

Anil, please try with this.