Skip to Content
0

How to split a multivalue object into separate columns on the same row?

Apr 16 at 12:31 PM

30

avatar image

I have an object [Review Type] that can, but not always, have multiple values for a given unique ID [Idea Number]....Currently the report is showing multiple rows when there is more than one [Review Type], but I want to display all of them on the same row but in separate columns. See below for example (current state, then desired state):

Any help would be much appreciated!

Thanks,

Phil

reviewa.png (5.5 kB)
reviewb.png (3.7 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Apr 16 at 12:58 PM
0

Create cross-tab and measure variable for Review Type.See attached screenshot.Later you can change the header values to "Review type"


capture.png (16.2 kB)
Share
10 |10000 characters needed characters left characters exceeded