Cross join in Spotfire
I am trying to create a movement field by calculating [Current Period Amount] - [Prior Period Amount], however what I have found is that if [Prior Period Amount] doesn't have a row for the current period then the [Prior Period Amount] doesn't come through. I have tried to perform these calculations on a graph/table by using the (PreviousPeriod([Axis.X])) method to some success. However other restrictions in my data prevent this from being a viable option.
I'm wondering is there any way I can perform a cross join in Spotfire? I have noticed that a Cross is not one of the available joins on the list when inserting columns, but am curious to see if you guys have found any workarounds.
Any assistance you can provide would be greatly appriciated, thanks!