Nguyen Ngo Posted March 2, 2020 Share Posted March 2, 2020 Hi All, I'm new to Spotfire and I'm tryingto 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 Link to comment Share on other sites More sharing options...
Shashank Gurnalkar Posted March 3, 2020 Share Posted March 3, 2020 Hello, I created a calculated column [test] with the following expression: Last([revenue]) OVER ([ticket])After that, I created another calculated column [final] with the following expression that achieves the use case: If([fiscal_year]!=2017,[revenue] - [test],[revenue])Please refer to the attached analysis file. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now