September 12, 2018 at 1:30 pm
I have row group as Test. And column group as Period.I have two columns-Count and Count1 as values.
I want to color the Count column of 2018-08 as Yellow when its greater than 2018-07 and Red when its less than previous period else do nothing. For Count1 column i want to change the font to red color whenever the value is greater or lower than previous period else do nothing. Period is not hardcoded. its changes depending on parameter. It wont always be 2018-08. but it will always be 2 consecutive months (2018-08 & 2018-07 OR 2018-07 & 2018-06 etc).
Tried below formula but it changes color for every row. One row as yellow and other as red.
=IIF(SUM(Fields!Count.Value) > Previous(SUM(Fields!Count.Value)), "Yellow", "Red")
September 14, 2018 at 9:06 am
This is NOT going to be easy.... First we'd need to know what your dataset looks like. Because there will always only be two periods, you may actually want to do this in T-SQL as opposed to SSRS, but again, need to see your dataset and the supporting query first. Too many dynamic things makes for a "hot mess"...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply