Help in data display between a range of Quarters

[#1]

Hello All,  I am trying to create a table to display values between specified Quarter's only. For instance , If i select Q1-2013 , the table should display seperate columns from Q1-2012 to Q1-2013 (last 5 quarters values) .  Can somebody help me out here ??

[#2]

Hi Ravi,

You can achieve it by defining a couple of variables and using set analysis in your expressions.

In attached .qvw file I have done it for last 2 quarters but if you want you can continue in same way.

I hope it will help you.

Best Regards

Ersan Alkan

[#3]

Thanks Ersan ... that was helpful

[jagan]

Hi Ravi,

Try this expression

=Sum(<YearDimension=, MonthDimension=, QuarterDimension=, WeekDimension=,

DateDimensionName={'>=$(=QuarterStart(Max(DateDimension), -4))<=$(=Date(Max(Date)))}>} MeasureName)

Replace YearDimension, MonthDimension, QuarterDimension, WeekDimension, DateDimensionName with your corresponding field names if any.

Hope this helps you.

Regards,

Jagan.