Top 5 rows colors in Pivot Table Qlik sense

[Karthick30]

Hi Team,

 I have 2 Dimensions and 2 Measures. I created a Pivot table based on that. Now i need to  specific any background color for top 5 rows and seperate colors for Total row alone. Can someone Please advise on this.

I enabled total row , but when i give some color , all datas in the pivot table changing according to that. 

Also , for top 5 rows, any logic we have to specify colors?

[vinieme12]

like below

if(rowno(total) <=5,lightred(),blue() )

use rowno() if you need top 5 within each group

of if you need to rank top 5 values

=if(rank(total sum(measurefield))<=5,lightred(),blue() )

[Karthick30]

Thanks , but I dont want to show top 5 within each group. 

Overall view, I need to show first 5 rows.. Any change of code required?

[vinieme12]

Just use the one with rowno(total)

if(rowno(total) <=5,lightred(),blue() )