Create a tier label based on the aggregate value of the client instead of the account level
Wondering if somebody can help me with the creation of Tier Labels based on the aggregate values at client level and not the individual account.
My data is organized as follows
This is what I was doing but I got stuck with the creation of the labels and the filtering of the products I need to report at client level
SELECT Reporting Month, Client , sum(balance) as Clientbalance
FROM TABLE NAME
WHERE Product Type IN ('DDA','NOW','MMK','OVN','TDS')
GROUP by "Client"
The lables I need would depend on the ClientBalance from Above and they would be 3 :
100M - 200M