Forum Discussion
warrencowan
Kudo Collector
Kudo CollectorNeed help creating date delta columns
I have a value in a column, eg (visits), and in another column I have the (date). I also have 3 rows for each date, because I have 3 different stores (StoreID) with a vlaue for visits I want to b...
you may also take a look at lookupvalue() function ...
warrencowanKudo Collector
Kudo CollectorThis is my data structure btw before anyone asks :smileywink:
| Date | Visits | Store | Daily Delta |
| 01/01/2015 | 3 | London | ? |
| 01/01/2015 | 2 | London | ? |
| 01/01/2015 | 3 | London | ? |
| 02/01/2015 | 5 | Leeds | ? |
| 02/01/2015 | 6 | Leeds | ? |
| 02/01/2015 | 1 | Leeds | ? |
| 03/01/2015 | 3 | Manchester | ? |
| 03/01/2015 | 4 | Manchester | ? |
| 03/01/2015 | 1 | Manchester | ? |