Grouping

[CidneyB]

Hello all,

I am trying to figure out a way to output my current data (shown below in attachment) into groups.

I have a business area but within the business area there are several different areas, I am looking to output only the rolled-up business area. (which I can easily do). However, there is one business area that I want to leave broken out. I hope my attachment will illustrate what i am looking to do. 

Thanks!

[FinnCharlton]

Hi @CidneyB , think that this workflow follows your logic. Not sure about the sum for 'Distribution' in your output though, is it correct? If so, why is the total for distribution higher than A+B+C?