Spot/Highlight Minimum and Maximum value(s) in each row in Matrix report in SSRS :)
Hi all, How are you doing? Today I would show you; how you can highlight minimum and maximum values in an each row of matrix report in SSRS. Again, “there are lots of ways“, but that depends on what is your solution framework. If you are using standard T-SQL queries for reporting, then itβs easier to write this min-max logic in query itself. But if you are using SSAS cube then you have to write custom MDX (i.e. calculated column/”Member” in Cube’s term) and do comparison in SSRS report in each row. I can show you even simpler way where … Continue reading →