Science is more than a body of knowledge; it's a way of thinking. A way of skeptically interrogating the universe with a fine understanding of human fallibility.
Good day, not a member, but I've watched your videos and they have been very helpful, so thank you in advance. I am building a report based on =sumvalue in different currencies (i.e. Euro, USD, GBP etc). I have those values based on previous months sales. Now I need incorporate the top 3 sellers by exports and top 3 in imports. I am figuring another query and doing union to put them together (my logic, could be wrong). But looking for the proper formula to create those 2 seller blocks to my report.
Thanks.
Marc
Sami Shamma
@Reply 6 months ago
First get your totals with an aggregate query Aggregate Query Then do a select using the top 3 Top X Then you can use union to put the data together
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Visitor Forum.
