I need to display blue color for max Revenue and red color
for min Revenue by using condition formatting how it
possible........?

Answer Posted / nasa

first just find the max revenue and min revenue by using
singleton separately. after that write a condition.

if(list_query1.revenue=query2_maxrevenue) then ('Blue')
else
if(query1.revenue=query3_minrevenue) then ('Red')


i think it will work...

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?

746


What do you mean by query studio?

699


What are the steps to import the two data sources in framework manager?

793


What is the difference between ‘macro’ and ‘prompt?

743


how to connect datamarts

2554


If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.

1882


In my report i want display sales rep name, country ,city how to achieve this by using repeater table

1756


What is difference between informatica power mart and power center?

757


What is difference between page break and section report?

943


What is a Datastore in Cognos?

1015


What are the types of folder present in cognos?

851


Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

826


Explain the different types of views used in cognos.

716


----------------------What are the User Securities?

1631


What are types of batch available in cognos?

732