Link to home
Start Free TrialLog in
Avatar of tanj1035

asked on

SSRS Row visibility

Hi, please see the attachment of my table. I may need your help on the row "Trending % " visibility.
In this table, there are a few expressions
1) 1st column - 1st row: if it is a current month (not a full month), the field will show * with monthname. i.e. April *
=iif (monthname(month(today()))= Fields!MonthName.Value, Fields!MonthName.Value+"*", Fields!MonthName.Value)

2)2nd, 3rd, 4th, 5th column - 2nd row: it calculates the tranding % from first month and the second month.

3)5th column - 1st row: lookup function from 2 datasets
=Lookup(Fields!MonthName.Value,Fields!MonthName.Value,Fields!UniqueDeals.Value, "UniqueOpportunity")

What I need to do :
I want to hide trending % row when it is not a full month, since the calculation does not make any sense. As you see -86.49% is based on a partial April data.

I still want to show trending % row when 2 months are full month, since the calculation is reasonable. i.e. February , March.

Many Thanks!
Avatar of Nico Bontenbal
Nico Bontenbal
Flag of Netherlands image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tanj1035


Thanks, based on your suggestions, I used

=iif (monthname(month(today()))= Last(Fields!MonthName.Value), true, false)

in the expression. And it works!!

Many thanks.