In Spotfire I am looking to create a column in a cross table to show day-on-day movement or delta.

Hi

 

In Spotfire I am looking to create a column in a cross table to show day-on-day movement or delta.  My data has for example:

 

Name  |        Monday 2nd          |          Tuesday 3rd      |      Wednesday 4th   ...

           |   Balance 1 | Balance 2 | Balance 1 | Balance 2 | Balance 1 | Balance 2 ...

ABC    |       10        |       20       |         5        |        23      |          8      |         21     ....

XYZ    |       20        |       21       |         15      |        20      |        18      |         9       ....

 

So essentially there are two different balances per day, per name.  I want extra columns so show the change per balance per day per client.  So there would be two additional columns called say "Change 1" and "Change 2" for each name.

Hopefully this can be understood as finding it hard to explain... but does anyone have any ideas on how to achieve this?  Another note is that every day additional daily data will populate, so needs to be some kind of dynamic formula to point to the date column I guess rather than a static one which specifically uses "Monday 2nd" or "Tuesday 3rd" for example.

Any help would be appreciated!

 

Thanks

Jason

Login