hi How Can we create rank in our report?i feel difficulty
pls expain me with ex,pls pls........

Answer Posted / annareddy

If u find the top 5 sal :
Create quires with Product type, Quantity, create Rank
column with rank(quantity)
Query1 give filter Rank<=5
Change the filter Application property from Before Auto
Aggregation to After Auto Aggregation.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a Folder?

677


WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

5972


What is the difference between the standard and metrics folder?

501


What are the considerations regarding performance kept in mind while setting up cognos?

562


-----------------What is Determination Model?

1689






What do you mean by drill across?

573


What is an olap designer?

526


What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?

3917


what is model and say about process how to create model and how to test model?

553


What are the message flows?

555


hi i need to rename a file in cognos8? can anyone help me out how 2 do it? pls suggest some solution such as using a batch file or using a procedure node or anything to rename the file

1938


What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?

544


Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..

1748


What is the difference between regular dimension and derminant?

1685


How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

2157