LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

I would like to be able to do a count of total customer by, BAN STATUS, CYCLE, MONTH & YEAR.

Input file looks like this:

CUST # Cycle month year Ban status
1 2 2 2015 open
2 2 2 2015 CAN
3 2 2 2015 CAN


Desired output

Total BAN, Open BAN's, CAN BAN'S, MONTH, CYCLE, YEAR
3 1 2 2 2 2015


Thank you in advance for your assistance

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

See attached. Most of the work is done in the Agg Ex node. I added a Pivot Data to Names node after it to get the CAN/Open status counts as one record.
Attachments:
countByGroup.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: andycooper

I've taken the work that Roger has done and expanded this to include the total value and set the emit order. There are a couple of different ways the total can be added to the data so I have included both in the example below.

Create Group Summaries.brg