Group the data after filtered

[AliceLau]

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!

[binuacs]

@AliceLau One way of doing this

[Sebastiaandb]

Hi @AliceLau ,

Here you go :-)

This should do the trick for ya!

Greetings,

Seb

[KrishnaChithrathil]

@AliceLau 

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