Post reply

SSRS Indicator at Subtotal level

  • December 21, 2016 at 10:46 am

    #338780

    I have a report that is grouped by name. I have an indicator at the detail level that works fine. However at the subtotal level (by name) I do not want the indicator to display using the aggregated values. I want it to merely display the 'worst' value from the details of the group. So if there are 7 records for that particular name and they all have 'Green' indicators, then the subtotal level indicator would display 'Green'. Additionally, if there are 7 records and 6 are 'Green' and 1 record is 'Red' then I want the subtotal level indicator to display RED. After numerous attempts and looking on sites everywhere, I cannot find how to do this. Is this even possible??

  • December 21, 2016 at 11:39 am

    #1919216

    If Green and Red are the only Indicator values, then an expression like =MAX(Indicator) should do it. If they are all Green, the MAX value will be Green; but if there is a single Red, the MAX value will be Red.

  • December 21, 2016 at 2:37 pm

    #1919241

    Thank you for the hint! I've tried several complicated formulas to try to get this to work because I didn't think MIN/MAX would work for this. Although I can't reference the indicator in the expression, I created a calculated field that calculated the value and hid the column. Then I used the indicator to look at this field and used the MIN function.

    =IIF(MIN(Fields!GoalResult.Value) = 0, "0","1")

    Thanks!

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

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