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
guys any help Pls....
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