Forum Discussion
PatrickByGecko
Helper V
3 years agoCrossjoin between 3 tables with summarize and filter.. failure
Hello
Is it possible to make a crossjoin between 3 tables with a filter on equality of Year and Month between them? I mean I only want the crossjoin work for the items which respect this equality?
Because the error message looks to say it is not, the columns I need and on the filter can't be used because they are present on Crossjoin Instruction. And when I suppres this columns on Crossjoin instruction, I'm told that they don't exist for the filter condition...
Here is the screen shot =>
Thanks for your help.
Thats's right, thank you very much.
2 Replies
- lbendlin
Super User
Your crossjoin cannot result in duplicate column names. Rename columns like [Annee] to remove the conflict.
- PatrickByGecko
Helper V
Thats's right, thank you very much.