Aggregating certain conditions into one

Answered

Comments

1 comment

  • Avatar
    Shawn Springstead

    You should add it on the cube level.
    So you could create a new field, and then using a case, you check if the row is one of the types you want to group or not. It would like something like:

    CASE

    WHEN value IN ('sports', 'movies', 'games'...) THEN value

    ELSE 'other'

    END

    2
    Comment actions Permalink

Please sign in to leave a comment.