Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Colleagues, hi!
I have one simple table with Date field and some Sales value.
Next my script load second table only with one field Date2. This tables are not connected with each other and my task to make pivot table, which must contain Date2 dimension and sum(Value) for such logic
Date2 | Expr |
01.11.2016 | Sales for 01.11 from Date1 |
02.11.2016 | Sales for 01.11-02.11 form Date1 |
03.11.2016 | Sales for 01.11-03.11 form Date1 |
04.11.2016 | … |
05.11.2016 | … |
This calculation must be implement only by expr, not in load script.
Have anybody ideas how to make it?
Thanks.
hi
use this expression
sum(if(Date2>=Date,Sales))
attach is an example