conditional fomatting

[devardekartb]

I want to highlight top three records of each column in my cognos report who are having fact data.Along with the top three values the dimension data related to those columns also needs to be highlighted.Please advise.

[Vivekmore23]

Hi

Depending on the fact data condition use the rank function. This would be available by adding one calculation using inbuilt functions. Functions --> Summary Functions --> rank ([column name])

e.g. to get top 3 salary the function would be rank (salary).

once you get he rank, use variable to apply conditional style  :)

That should do it

Regards
Vivek M