|
Re: Display Values in single row instead of multiple rows [message #1749349 is a reply to message #1749346] |
Mon, 05 December 2016 18:31 |
|
You are showing far too little information.
Your report presumably is grouping by something - user, access level, whatever. You appear to have scenario appearing as a field in the detail level.
What you need to do is aggregate so that you can collapse all of the scenarios into a single row. therefore, in your group footer, you would show max(scenario_1_value), max(scenario_2_value) etcetera, which would be the X or null values.
That's as much detail as we can give based on the information you presented.
Richard
|
|
|
|
|
|
Re: Display Values in single row instead of multiple rows [message #1749415 is a reply to message #1749377] |
Tue, 06 December 2016 14:04 |
|
(1) Note your formula for S1 appears to be incorrect - it plants an X if scenario = SCENARIO2, probably should be SCENARIO1.
(2) Your data row from the cube is atomic at the user/group/scenario level. But you want your report to collapse all scenarios onto the same line.
Therefore you need to create a group in your TABLE on userid (assuming that a userid can be associated with only one groupname). Move the userid through groupname fields down into the group footer. Then, in the group footer, add Aggregation entries (using the MAX function) for the s1 through s8 elements.
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.03792 seconds