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
Conditionally hide the contents of 2011Q3 in the layout of the list?