Hi.
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
Reporting month
Account
Product Type
ClientNo.
Balance
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
100M - 200M
>200M