Grouping and Summation Help

[former_member440205]

HI All,

I need some help with grouping and summation. I'm not getting the result for Team A and B vertically. Below screen shot is the data piece and the following piece is what I expected for the end result.

what I have done, I have a grouping called "Company" and "Team" and use sum(Quantity, Company). When I use sum(Quantity, Team) for "Team"., I get the same results for "A" and "B" which equal to 500. Any input greatly appreciated.

Thanks,

Frankie

[DellSC · Accepted solution]

In order to get the data in the format you're looking for, you'll need to do one of two things:

1. Use a cross-tab. This will pivot and summarize the data for you.

2. Use a command (SQL Select statement) that pivots the data in SQL to get the data for your report.

-Dell

[former_member440205 · Accepted solution]

Thanks Dell. Cross tab works.!