Help with Matrix Sort on Pivot column agains row group subtotal

• acampoma

  SSC Rookie

  Points: 35

  More actions

  September 13, 2017 at 10:13 am

  #332568

  Can anyone PLS help me.
  I am having issues sorting on a specific column in a Matrix. The column is based on a pivot value (90 Days) and needs to sort my group subtotals descending.
  in the group properties under sorting, I use the expression
  

  =sum(iif(Fields!Period_Sort.Value=5,Fields!TTL_Business.Value,0))

  and I get an error
  Thanks in advance
  Alex

  

  

  

• sgmunson

  SSC Guru

  Points: 110639

  More actions

  September 13, 2017 at 1:04 pm

  #1959319

  TTLBusiness.Value must be something other than an integer, and your 0 value might just need to be converted to it's datatype using the appropriate conversion function.   Try that and let me know if it solves the problem.

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)