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...
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