Column rename

  • You're creating a member [Amanda P-D] that adds Amanda D and Amanda P., but then you don't use it in your query.  Jut looking at this, it looks like your report brings back the submissions for Andrea W, Ann F and Aubrey S.

    Am I guessing correctly?

    What if you just add to your columns axis:

    SELECT ( { [Underwriting Facts].[Underwriter].&[Andrea W],

    [Underwriting Facts].[Underwriter].&[Ann F],

    [Underwriting Facts].[Underwriter].&[Aubrey S],
    [Underwriting Facts].[Underwriter].&[Amanda P-D]

    } ) ON COLUMNS,

    I'm just guessing here.  I hope that sparks a thought on your part.

    Good luck,
    Rob

  • Thanks, I'll give it a try.

    There is an exception to every rule, except this one...

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply