Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ??
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
Thanks Ersan ... that was helpful
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.