Forum Discussion
union in report
Hi Friends, We want to build a revenue report, which include sales order, interests, free text invoice items. Those are from different tables, with quite different columns. How can we build a u...
River
The shot answer is you can related the tables with a column (product or date, etc), once relationship is activated, you could put the columns in one visual. However, it is very much depended on your model so more information is required for a detailed solution.
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Paul,
When you link them through a column, isn't it a join not union?
