Hi
I'm feeling a bit daft that I have to ask this question but it's driving me mad.
My users are develoiping list reports from a relational package and ranking on measure column, which works great. They then want to just see the top n rows based on the rank. We've tried using a filter to say something like [rank] <=5 but cognos (8.2) seems to be ignoring the filter and still returns all the data.
Can any body help?
Try changing the Filter's setting to be AFTER aggregation, rather than before aggregation.
If this still doesn't do it, create a Reference Query from which to base your report, with the original query as its source, and put the Rank <= 5 filter in the Reference Query, instead.
Thanks for the help. I couldn't get the suggestions to work but added a running count to the report and managed to filter on that.
Thanks again
Guys, Im wondering if you can help me out too - my problem is similar I think. I have a set of accounts where I am sorting by the rank. I only want to show the top 10 accounts and normally, a simple filter would help me out here. But on my report, I have a number of different revenues (week, month, year) but think I can only filter on one?
The problem with that is that it will only return data for that one revenue column, all the other timeframes come up as 0 which is logical I suppose. But is there a way around this? To sort and filter on one but show them all?
I hope this message/request makes some semblance of sense,
Thanks in advance for your help,