Forum Discussion

alice25's avatar
alice25
Regular Visitor
3 years ago
Solved

Group by

Hi everyone, I am struggling with grouping the below set of data:   1) Firstly, I want to group the highlited columns. My final result should be: one row with date and total amounts for both colum...
Need Help
alice25's avatar
alice25
Regular Visitor
3 years ago

Hi Ankit,

 

Thanks! There is one issue with backlog value - it will not be always max value.

 

Please find below the example:

Last date of the weekIncomingShipmentBacklog
12/18/225036.31031782
12/18/220031143
12/18/2201988.0231143
12/18/220026746
12/18/220026746

 

Expected:

Last date of the weekIncomingShipmentBacklog
12/18/225036.311988.0226746

 

  • AnkitKukreja's avatar
    AnkitKukreja
    Super User
    3 years ago

    Hi alice25 

     

    Not possible with group by as we can choose either max, min, sum, avg, count etc with the group by.