Trend analysis in relational model

[RKMI]

Hi,

I have a relational model and I'm trying to show trend per quarter, if I select prior year last 12 months.

Current output:

              ProdQuant1 % of Growth Trend
2012Q3         65             5%           +5%
2012Q2         60             5%           +5%
2012Q1         55             5%           +5%
2011Q4         50             --%           --%

The problem I'm having is I need to compare the 2011Q4 with 2011Q3 and also capture that trend as well. Any thoughts how to filter 15 months but show only last 4 quarters trends in a relational model?

Desired output:

              ProdQuant1 % of Growth Trend
2012Q3         65             5%           +5%
2012Q2         60             5%           +5%
2012Q1         55             5%           +5%
2011Q4         50             5%           +5%             Assuming the 2011Q3         45             --           --


Thanks,
RK

[blom0344]

Conditionally hide the contents of 2011Q3 in the layout of the list?