Spotfire calculate column base on another column

Hi All,

I'm new to Spotfire and I'm trying to create a calculated column to compare the revenue between 2 years.

The table look like this:

ticket
fiscal_year
revenue
ABC 2018 400
ABC 2017 200
XYZ 2018 600
XYZ 2017 300

I would like to Subtract the revenue from the lastest year to the older one

After that the result should be like this:

ticket
fiscal_year
revenue
result
ABC 2018 400 200
ABC 2017 200 200
XYZ 2018 600 300
XYZ 2017 300 300

 

(1) Answer

Login