on 10-25-2016 5:14 PM - last edited on 02-03-2024 6:10 PM by postmig_api_4
Good Day.
I have this simple query:
select yr_mth_nbr, sum(Txn_amt), row_number() over (order by yr_mth_nbr) as rob from tb_c2_zz5_dlvry_chnl_m_ddp where yr_mth_nbr>='201511' group by yr_mth_nbr;
Which returns:
YR_MTH_NBR;SUM(TXN_AMT);ROB
201511; 30,032.13; 1
201512; -254,763.77; 2
201601; 40,074.39; 3
201602; -407,180.09; 4
This is the result set I wish to get. How do I perform this same sql logic in a calculated view?
Thank you in advance for any assistance.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.