How to do quarter analysis?

[#1]

Hi,

I got sect of quarters and year, I want to analysis 1Qtr of 2013 VS 1st Qtr 2014 as well as 2nd Qtr of 2013 VS 2nd Qtr 2014

please go through the attachment and help me out. Thanks!

[deepakqlikview_123]

Hi Mafaz,

You can use alternate state for this ctreate the state in document properties general tabl and apply same state in chart properties for comparison.

Thanks,

Deepak

[PradeepReddy]

Take 2 dimensions and one expression like bellow..

Primary : Quarter

Secondary : Year

Expression: Sum(Sales)

[#4]

Hi Mafaz,

For Qtr wise analysis you create

Dimension: Quater&' '&Year

Expression: Sum(Sales)

Hope it will help...

[#5]

but still I get the out put as below not how I wanted. I want to show Plan and Actual for same Quarter but deterrent two years  

[#6]

Hi Mafaz,

please provide some sample data ...

[VishalWaghole · Accepted solution]

Hi Mafaz,

Please refer this file, Hope u want this....

-- Regards,

VIshal Waghole