Post reply

Matrix sorting by row group totals

  • February 14, 2012 at 2:36 pm

    #255750

    Hello all,

    Report Parameters:

    Fund (multiselect)

    I have the following matrix report structure:

    ----------------Fund1--------Fund2

    Group1---------25(total)------17(total)

    Account1------20------------8

    Account2------5-------------9

    Group2---------16(total)------26(total)

    Account3------10------------12

    Account4-------4-------------6

    Account5-------2-------------8

    Group3---------10(total)------12(total)

    Account6-------7------------6

    Account7-------3------------2

    Account8-------1------------4

    I want to Sort the matrix report by the left Fund1 column based on the Group1,2,3 Totals.

    In my "mock up" I have displayed the report with the correct sorting(Bold). I ve looked everywhere and tried everything I can think of.

    I will greatly appreciate your help!

    Thanks,

    J

  • February 16, 2012 at 12:53 pm

    #1448104

    I found a way how to do that. Actually it turns out to be pretty simple.

    For those that might be interested here is how:

    Create a temptable and populate it with Group.IDs and SUM(group totals) for the Fund1(Column) on the left and then join that temptable with a LEFT OUTER JOIN in the main Query to the Group.Ids and use the SUM(group totals) for the Sorting in the RowGroup.

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

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