Mario S. Posted November 4, 2019 Share Posted November 4, 2019 Hello, I would like in a base under spotfire with three columns [store], [sale date], [amount], create a calculated column where for each row we have the sum of the amounts of the last 15 days. I thought to use the function "lastPeriods" but the number of sales can change and I can't define the number of nodes. Someone would have a solution Thank you. Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted November 6, 2019 Share Posted November 6, 2019 Why would you not be able to use lastperiods, can you please elaborate on it. It would be helpful to get accurate ans if you share sample dxp showing the expected output, which you are not getting currently. 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