If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to find top 10 values from a list report

Started by cogrep, 26 Oct 2012 05:34:05 AM

Previous topic - Next topic

cogrep

hi guys

bit new to this post

i have a requirement to pull the rank based on the count
for example i have node , summary, tally(fact),
now i have grouped the list report by node and i have taken the count (tally). but when i am assigning the rank it is assigning to sum(tally) not to count (tally) and i also want to filter the report based on the rank like top 50 or top 10 any help is much appreciated .
thanks in advance for help

cogrep


cogrep

to simplify my requirement

node     Summary       tally
abc        123,asxv        100
              1234,avc         3
--------------------------------
count ----                   2 Rank should be 2
--------------------------------
cde         adf213         30
               abcd23         1
                xzc543        2
------------------------------
count-----------            3 rank should be 1
--------------------------------
the above is the sample report i am trying to prepare, but my rank function is not able to assign the rank correctly. when i say rank (count(tally)) it is assigning the rank based on the sum
for example   node abc is getting rank1 and node cde is getting rank 2 but i want in a reverse way and a filter along with this to filter top N records


Please guys any help is much appreciated