Null Value coloring Issue in Pivot

[Karthick30]

Hi,

 I have a request to show top 5 rows in specific color in pivot table. I have used the formula if(rowno(total)<=5, lightgreen()) in background colour, but I am getting like below ( its our issue)

it is ignoring null values. Is there any possibilities to show top 5 irrespective of null values. 

like this we need

[Andrea_Spinetti]

Hello @Karthick30, you could change the dimension in the table that has got the null values to the following: =if(isnull(Dimension), '-', Dimension)

This way your background color expression should work 😊

[Karthick30]

Thanks @Andrea_Spinetti . still same issue. I have 2 dimension and one measure. 2 dimension ( 1 as column & 1 as row). changed both dimension formula as per your formula. but still same error

[Andrea_Spinetti]

@Karthick30 would you be able to attach a sample app so I can better assist? Thanks!

[vinieme12]

Just replace null values with 0's

=if(sum(Measure),sum(Measure),0)

[Karthick30]

Hi @Andrea_Spinetti 

 sample app attached with existing issue.

[Andrea_Spinetti]

Hi @Karthick30, those aren't null values but missing values. The only way to solve the issue is to add extra data for all the missing combinations.