Skip to Content
avatar image
Former Member

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 16 at 12:58 PM

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

    Add comment
    10|10000 characters needed characters exceeded