Prior Year to sit under current year in a table

[#1]

Qlikview Community,

My problem is that I would like to represent prior year under the dimension of current year.  However at the moment using this code:

sum({<[SAP Year]={$(=[SAP Year]-1)}>}[Net Sales Local Currency]*[ER SAP CY])

but getting this result:

	2012	2013
Sales		1,915,861
Prior Year	10,500,564

But would like it to look like this:

	2013
Sales	1,915,861
Prior Year	10,500,564

[#2]

Transpose this tale and you would be able to do that. Also Make expressions for both the Sales and Prior Year sales.

-Abhinava

[Gysbert_Wassenaar]

Don't use a dimension, only expressions. See attached example.