Jump to content

Calculate percentage difference in spotfire from previous values

Recommended Posts

I have a dataset with 2 types of vendors and each week contains different colors.

My requirement is to calculate the percentage difference of the particular color for the particular vendor from current week to the previous week.

for example: the percentage of color green for week 2, vendor A is 80%. Now I want to compare this with previous week's (week 1) green value of vendor A which is 40%. I want the output to say the percentage difference between the current 80% and previous 40%. The same applicable to Yellow color.

I am able to calculate the percentage of respective colors for each week for each vendor. I also created a new calculated column which gives the previous week number. But I don't know how to get the percentage of previous week and get the difference between previous week to the current week.

Any expert advices would be really helpful.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...