Post reply

SSRS Matrix Sort query

  • July 28, 2014 at 6:42 am

    #310402

    Good Afternoon

    I have a matrix within SSRS I am trying to sort on. My matrix looks like as below:

    --Months--

    Month A Month B

    Report A 12 32

    Report B 34 54

    Report C 11 2

    Report D 6 45

    Report E 15 12

    Where the numbers represent number of views. The month titles are dynamic so they update when a parameter is amended. Please can you tell me how to sort the list of report names by the column title Month B (this is a grouped filter where the data comes from a source called MonthNumber.

    Thank you in advanced.

    Abbie

  • July 29, 2014 at 5:17 am

    #1733143

    you should be able to go to the group properties for month then sort on the month field

  • July 29, 2014 at 6:31 am

    #1733171

    Hi Scott

    Thank you for your reply, unfortunately it won't sort by month as within the dataset itself month 4 and 5 are under one column (so it doesn't sort correctly) namely 'MonthNumber'

  • July 29, 2014 at 7:13 am

    #1733189

    I've managed to fix it by using the following sort fx within the row group:

    =Sum(IIf(MonthName = ParametersMonth, Views, 0))

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

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