I want to query profiles that have total purchase of brand X > total purchase of brand Y.
This data comes from a custom table where we only have the brand chosen by the profile and the total purchase. Brand is text type and the total purchase is floating number type.
I tried doing the query using the advanced function but without result.
Is there anyone who can help me?