Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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) 

 

 

 

 

 

What I want to see one line for.

 

NAME= ıs the same person

 

I want to see one line for  DATE = '30/06/2020', not 2. 

 

I want to group by the BRAND. It can be any of them MAx or MIN 

 

Here are the attachments:

 

Thank you,

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    6 years ago

    At the end, what i have done was :

     

     

    I group BY NAME,  

     

    and columns by ; Brand MAX and DATE MAX 

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thank you for this solution, however I need to make something during the query, not in the visual section 

      • rajulshah's avatar
        rajulshah
        Resident Rockstar
        6 years ago

        Hello Anonymous,

         

        You can click on Advanced and add columns that you wanted to Summarize in 'Group By' section.

         

        Hope this helps.