Hi Guys,
i want to create a table with Jet function where Jet generates automatically results for top 10 losses and wins of my customers.
1. Step i generated with Excel my date filter.
last month, for example october
beginning of the year, for example 1.1.2017
so i got NP filter: 01.01.2017 - 31.10.2017 and 01.01.2016 - 31.10.2016
2. Step
i want to create a jet function where i compare my results from 2016 to 2017.
Here is my problem, i want them automatically.
Any reason where i can start my function.
Its no problem for me to create it manuel, but i want to need it automatically.
1. - Is there a reason to tell Jet with row:
sale (MW) - NP filtre 01.01.2016 to 01.10.2016 "minus" sale (MW) - NP filter 01.01.2017 to 01.10.2017
Limit = 10; difference from above?
Hope you can help!
