Interactive sort on matrix

• jag7777777

  SSC Enthusiast

  Points: 113

  More actions

  December 5, 2012 at 6:12 am

  #393745

  Hi All,

  I've read that this is not possible - but, am hoping there are others like me that ignore stuff like that and still try and find a way anyway!:-)

  I have a matrix report that is grouped both on the rows and columns (see attached as an example).

  Using the attached image as the example, the row group is Item and the column group is Customer (with a sum of value and unit for each customer). The columns 'Description' and 'Item' are not in the column group.

  There's an interactive sort on the Description and Item text box that uses the Item group to sort by the Description or Item field - this works fine.

  However, if I try and add an interactive sort to the columns in the column group (e.g. the Value text box) to sort the Item group I get nothing at all? No change whatsover to the rows.

  I basically want to be able to sort the rows by any of the columns in the column groups - so for example, in the attached image - I have sorted on the Value column of the first customer on the lower table to re-arrange the Item group rows from that displayed in the upper table

  Has anyone found a way of doing this?

  Thanks,

  jag7777777

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  December 5, 2012 at 3:56 pm

  #1565958

  Click on the Customer text box properties and go to interactive sorting..

  In choose what to sort ..Select groups and in dropdown select the row grouping name and sort by column value ..you should be able to get it

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman

• jag7777777

  SSC Enthusiast

  Points: 113

  More actions

  December 6, 2012 at 9:35 am

  #1566241

  Thanks Chinna for you reply.

  I think this would work if you don't have column groups as well as row groups....

  ....I've also tried using RunningValue against the values but an error dialogue states this can't be used in interactive sorts.

  Logically, you would think you could be able to sort on the row group and an expression of either:

  SUM(Fields!Units.Value) or RunningValue(Feilds!Units.Value) - but it doesn't work

  Also,

  SUM(Fields!Units.Value, "ColumnGroupName") is not allowed!

  Any ideas anyone.....?

  jag7777777