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
What is a Folder?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What is the difference between the standard and metrics folder?
What are the considerations regarding performance kept in mind while setting up cognos?
-----------------What is Determination Model?
What do you mean by drill across?
What is an olap designer?
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)?
what is model and say about process how to create model and how to test model?
What are the message flows?
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
What is the difference between a cascading report and drillthru report? Why do we go for drill thru report?
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..
What is the difference between regular dimension and derminant?
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?