Search code examples
sql-serverreporting-servicesssrs-tablixssrs-groupingssrs-2012

highlight value that is x% higher than preceding value (SSRS grouping)

I have a report that measures average execution per hour.I would like to higlight the hours where executiontime is x% higher then the last. So the reports now looks like this:

DATE | Time  | average

8-4  | 11:00 | 4,2
       10:00
8-4  | 10:00 | 12,2
       9:00
8-4  | 9:00 | 5,2
       8:00

If x = 25 I would like to highlight 12,2 since it is more then 25% higher than 5,2.

What you see above are groupings: the actual dataset contains details per report:

Reportname | Time_of_execution | length_of_execution
Solution

  • You can use the Previous function to return the previous value of an expression

    With your data it should be something like

    =Previous(Avg(Fields!Alias.length_of_execution))