Multiple expression for each dimension value in straight table

[AKS_Qlik]

Hello,

I need to represent below data in a straight table.

The tittle column would be be a inline/excel load.

In the below scenario each tittle value has a different logic for calculation.

Currently i create three expression's to display Çurrent Year'value for corresponding dimension value.

How can 'Previous Year' and 'Difference ' be represented?

Tittle	Current Year	Previous Year	Difference
Gross margin / Tel .Sales %	500	400	100
Gross margin / Concession Sales %	600	500	100
Gross margin / Main Stores Sales %	900	300	600

[chrismarlow]

Hi,

I would do a pick/match like below/attached toy application, but sounds like you already have something for Current Year, so what does that look like?

Cheers,

Chris.