Forum Discussion
RANKX Grouping
Hi. How can I build a table which ranks the top 10 clients by sales of a sales table, and also show a final single row in the table which group all the sales of all the "others clients" not included ...
Hi alonardi
When you use the UNION function, to joins two tables together, one on top of the other. Both tables need to have the same number of columns and I'm guessing this is the problem here. So it is probably just a case of changing the logic in the VAR OtherSales line to match.
Yes, sure Phil. I use unions and joins frequently, but I don´t work with variables.
I don't understand which result will each var line, so I'm disabled to modify the structure of the OtherSales line.
Can u please see the screenshot I upload, so you can light me in my darkness?
Thank you so much.