Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to perform aggregation like sum and count on my data.But the case is I can not use taggregateRow component.
for example I have data set like
cust_id|cust_name|cust_rec_type|amount
1|john|BP|8000
2|jeevan|SR|8900
3|jay|BP|8078
4|harish|BS|8000
1|john|BP|800
6|Anshul|PR|20000
3|jay|BP|808
2|jeevan|SR|800
9|john|SR|8900
2|jeevan|SR|80
I want to perform group by on cust_id and sum of amount for each cust_Id.
Can anybody tellme how can I achieve this?
Hi,
Are you looking for the following output?
Regards,
HI,
Thanks a lot for this suggestion. I tried exact same way. but getting different output as below PFA screenshots.
1|john|BP|8800|2
2|jeevan|SR|18580|5
3|jay|BP|27466|7
4|harish|BS|35466|8
6|Anshul|PR|55466|9
9|john|SR|64366|10
can you please suggest on this
@sourabh93,you move the pre_cust_id variable port to down the all variable fields,your issue will be fixed.