Hello,
I have a project that would need to use the below data to get 2 set of output, and then group into one table.
Output 1. Filter out Client that does not have Product=Apple, and then display maximum of 2 client's data with descending order according to the price
Expected output:
Client | Price |
E | 9000 |
D | 1500 |
Output 2. Filter out the rest of the client that is not display in Output 1 and group the data as "others"
Expected output:
1500+3000+1200=5700
Client | Price |
Others | 5700 |
Final output: Combine both table into one
Client | Price |
E | 9000 |
D | 1500 |
Others | 5700 |
Can anyone advise? Thanks a lot!
Is this something you want?
you can also try adding few more records to the below attached workflow, to check if it's working as intended.
thanks,
Krishna