You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!