Forum Discussion
Group BY function HELP
Hello, Could you please tell me if it is possible by using 'GROUP BY' to make these line to 1. SO I want to see 1 name 1 brand (which can any of them ) and the date (which is the same) ...
At the end, what i have done was :
I group BY NAME,
and columns by ; Brand MAX and DATE MAX
Anonymous
Maybe you can used a matrix:
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.
Thank you for this solution, however I need to make something during the query, not in the visual section
Hello Anonymous,
You can click on Advanced and add columns that you wanted to Summarize in 'Group By' section.
Hope this helps.
At the end, what i have done was :
I group BY NAME,
and columns by ; Brand MAX and DATE MAX
