previous year calculation in crosstab for YOY growth

[prabhakar2442]

Hi Members,

I have cross tab report with some data items as year and measures (cost,units,revenue) on columns and products in rows.
how can I add the previous measure(cost) for year( eg: for 2016 it should have 2015 cost in column).
Please look at the attachment. I need 2014 revenue in 2015 year. please help on the calculation. Thanks,

Regards,
Prahbakar

[MFGF]

Hi Members,

I have cross tab report with some data items as year and measures (cost,units,revenue) on columns and products in rows.
how can I add the previous measure(cost) for year( eg: for 2016 it should have 2015 cost in column).
Please look at the attachment. I need 2014 revenue in 2015 year. please help on the calculation. Thanks,

Regards,
Prahbakar

Hi,

Are you using a relational or a dimensional package?

MF.

[prabhakar2442]

Hi,

Its Relational model.

Regards,
Prabhakar.

[MFGF]

Hi,

Its Relational model.

Regards,
Prabhakar.

Hi,

Not so easy, in that case. The approach would be to create another query that joins Year - 1 to your current query based on Year. Bring the items from your current query, plus the revenue from the second query into the resultant join query, and base your crosstab on this.

MF.