Difference between two periods in a crosstab

[pasinienrico85]

Hi everyone,

I've a crosstab similar to this one:

FRUIT	2014	2015
apples	12	85
peaches	74	36
bananas	54	82

and I would like to obtain something like this:

FRUIT	2014	2015	Difference between 2015/2014 (delta)
apples	12	85	73
peaches	74	36	-38
bananas	54	82	28

I mean, it's there a way to intercetpt the value of a field in the single period (e.g. 2014) and use it for a custom count?

Thank you very much

[pasinienrico85]

Solved!

Just using two different measures.