Conditional Visibility

[BouwerVa]

Hi

I created a Pivot Table.

But I only want to show the Rows in red.

Any Suggestions:

[JordyWegman · Accepted solution]

Hi,

Use the conditional coloring code also for your measures. But instead or returning LightRed(), return null(). Then you should go to Data Handling in your pivot table properties and disable include null values.

Jordy

Climber

[BouwerVa]

It Worked somewhat but it still will not hide the null values.

• "Include Null Values" is unticked in all Dimensions
• My Loan at's Formula : 
  • if(sum(if(TTYPE ='Lo',1)) > 3, sum(if(TTYPE ='Lo',1)), Null())
• My Loans Granted Formula:
  • if(sum(if(TTYPE ='Lo',1)) > 3, sum(if(TTYPE = 'Lo', CAPITAL)), Null())

Not sure what I'm doing wrong