Create SQL Group By Effect in NR Report

Question: Is there a way to use the NR report building tools to create the same result as a SQL "GROUP BY" clause?

Background: I'm trying to create a report in NR, which pulls data from FCCS. On the Y axis, the report will have specific Account members. On the X Axis, the report will have specific Entity members and specific Intercompany members. However, I do not want the different Intercompany members visible. Rather, I want a single column for each Entity member, and the value of each cell should be the sum of the specified ICP members for that Entity and Account. The POV for all other members is the same for all dimensions.