Count records for some criteria

[Lydieatantra]

Hi Alteryx Team,

Im newby in Alteryx Team, need your advise to how can i create the workflow as my expected below.

Currently i need to record count based on some amount record. I have tried but the result is shown for each record amount based on description.

Current

Source	Transaction Amount	Count	Description
Bank Statement	250	1	BR Sunter
Bank Statement	250	1	Branch Sudirman 1
Bank Statement	250	1	Branch Sudirman 2
Bank Statement	225	1	BR Sunter 1

Expected

Source	Transaction Amount	Count	Description
Bank Statement	250	3	BR Sunter
Bank Statement	250	3	Branch Sudirman 1
Bank Statement	250	3	Branch Sudirman 2
Bank Statement	225	1	BR Sunter 1

This is my currently workflow that i have created in alteryx :

Thank you and regards,

Lydiea

[grazitti_sapna · Accepted solution]

Hi @Lydieatantra , try this if it works for you?

The reason for count 1 for every record in your current output is you are grouping the records on the basis of description as well but the description is different for all the records therefore giving you distinct count.Please refer to the workflow attached for your referencce.

Thanks.

[Lydieatantra]

Thanks very much @grazitti_sapna, it works perfectly 🙂

Regards,

Lydiea

[grazitti_sapna]

@Lydieatantra , you are most welcome. Happy to help. 🙂