Re: HowTo implement a function independent to the filters
the real calcualtion is much more complicated.
I've posted a kind of snippet in order to find out how it actually mus be done if I'm in 2016 and I need to take a value from 2015 and 2014.
It seems not to work since the relation to the date of 2014 and 2015 is not available in 2016 ... I guess.
I've tried to setup a flag table ... in that table I try to push values from 2014 & 2015 to 2016... somehow
I cannot manage to creat a table with flags like this (compare with the screenshot above):
SALESDATA_YEAR SALESDATA_SALES FLAG
2014 10,00 € no (can create this record, 10€ are from 2014)
2014 20,00 € no (can create this record, 20€ are from 2014)
2014 30,00 € no (can create this record, 30€ are from 2014)
2016 10,00 € yes (cannot create this record, 10€ are from 2014)
2016 20,00 € yes (cannot create this record, 20€ are from 2014)
2016 30,00 € yes (can notcreate this record, 30€ are from 2014)
This way I hope to get this missing link between the years and then I can do the calculation by using the flag table ... but as I've said ... I cannot create such setting of the table in the load-script.