Pivot table top 5 values colour change

[#1]

    Hi Qlikers,

Please find the attachment.

I have pivot table drawn in qvw file.

now I want in fruit and reason desc null values should go down and last .

for fruit the order is Mango,Guava,grape etc....

now I want to change top 5 values colur should be green and those should come in descending order

kindly help me .

its an urgent requirement.

ASAP.

Thanks in advance.

[SergeyMak]

Hi Sampath,

Please show how you can get the descending order in pivot table for all Fruits and Categories in Excel file.

I ask you to do it because as I see, It could be done, only by One fruit by categories or for One category by Fruits.

To move Null values down just go to Sort and change the sort order to A->Z for both dimension.

Regards,

Sergey

[SergeyMak · Accepted solution]

To color TOP-5 in green use the following expression for background of Expression

if(Rank(Sum(Data))<=5,green(),white())

PFA

[sujeetsingh]

Sergy has provided you one way, you can make this more nested for assigning different colours to all top 5