Sorting report by Calculated Detail Field help. RRS feed

  • Question

  • User-781338610 posted


    I have a relativly simple drill down matrix that has 4 row fields, 1 column field and two detail fields.  The detail fields are a sum of column_count, and the second detail field is a percentage calculation : 


    is it possible to sort the report on the result of the above percentage calculation???



    Monday, October 31, 2011 12:13 PM


  • User-8475372 posted

    Yes, you can provide the same as expression (formatpercent(Sum(Fields!count_column.Value)/sum(Fields!month_index.Value))) in the sort expression option for the report. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, November 2, 2011 3:20 AM