Forum Discussion
Table Nested Joint - where clause
Hello I'm builing up a summary table of sales targets and past year sales. I would like to add a column to my table containing sales of a pre-set year (ie 2015). In the following formula, I...
Hello again
I'm really stuck and would appreicate any kind of support helping me to advance.
Maybe my question was not clear, please let me know if this is the case...
thanks
Ricardo
thanks for your support.
2 reasons :
- i use the year table for other queries and don t want to prefilter it
- I will use this "year sales" table to add 3 columns in the "target" table (containing the nested join fonction) : 2015 sales | 2016 sales | 2017 sales
Doesn`t it work if you just create a filtered copy (you don`t need to filter the base table) ?
Ricardo
