Avatar of tanj1035
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.
i.e.
=(Last(Fields!Deal.Value)-First(Fields!Deal.Value))/First(Fields!Deal.Value)

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!
Capture.JPG
SSRSMicrosoft DynamicsMicrosoft SQL ServerDatabasesDB Reporting Tools

Avatar of undefined
Last Comment
tanj1035

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Nico Bontenbal

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
tanj1035

ASKER
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.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23