QuarterYear selection for YoY

[#1]

Hello all,

i have a table with YoY% (comparison between 2 years), I have a field called QtrYear which will have values like 2014/Q1, 2014/Q2, 2014/Q3 etc.

Now, if I select 2014/Q1 from QtrYear field, table should display YoY% for 2014Q1 vs 2013Q1.

Kindly let me know how this can be done.

Thanks for your help.

Regards,

Sheela

[ecolomer]

You need to created a field with Q1, Q2, Q3, Q4 values and select this filed to have you need

[#3]

hi Enrique,

Thanks for your quick response.

I do have separate Qtr field in the application, but I wanted to know if YoY% can be calculated even when selecting values from QtrYear field.

Thanks,

Sheela

[PradeepReddy]

try something like this...

Current Year-Qtr:   sum({<YearQtr={'$(=maxstring(YearQtr))'}>}Sales)

Previous Year-Qtr:  sum({<YearQtr={'$(=((left(MaxString(YearQtr),4)-1)&right(MaxString(YearQtr),2)))'}>}Sales)

Modify these expressions as per your requirement...

[#5]

hi Pradeep,

thanks for your reply, but this does not seem to work.

Thanks

Sheela

[#6]

Generally users will select Year and Qtr and look at YoY,
in case, they select QtrYear, then also YoY should be displayed.

this is my concern.

Thanks

Sheela

[#7]

Calculate start month and end month and use addmonths() function