Group Data and Summarize

[traceystone]

I have a set of data that I would like to group and then summarize. I am not sure how to accomplish this. Here is a sample set of input data and the final output I would like to group and summarize. Can someone help me get started?

[Luke_C]

Hi @traceystone  - please share the logic on determining 'GL Group'

[Luke_C]

Hi @traceystone 

I think this should do the job if I understand correctly:

1. Round GL acct down to nearest 1000
2. Summarize by cost center, gl group, and total

[traceystone]

The groups are defined like this..

610000  (any GL that starts with 610)

615000 (any GL that starts with 615)

620000 (any GL that starts with 620)

692000 (any GL that starts with 692)

and so on.

[Luke_C · Accepted solution]

@traceystone thanks, I think the solution above will solve for it. Please confirm

[traceystone]

Thanks. That worked