This content has been marked as final.
Show 4 replies
-
Re: Top 10 - limited a result set to top n
Andrew Kratz Sep 11, 2011 4:18 PM (in response to Andrew Kratz)I think I can answer my own question. I added in a variable with the function of Rank(Activity count). Added that field to the table and then could use the table filter field to say only show rows where the rank is less than or equal to 10. That seemed to work.
-
Re: Top 10 - limited a result set to top n
Ted HoptonSep 12, 2011 6:16 AM (in response to Andrew Kratz)
Glad you figured it out, Andrew! I have some reports set up as "top ___" so I knew it was possible, but I would have had to open them and look at the queries to give you any specific guidance.
-
Re: Top 10 - limited a result set to top n
Andrew Kratz Sep 12, 2011 7:28 AM (in response to Ted Hopton)Thanks Ted!
-
-
Re: Top 10 - limited a result set to top n
david.sullivan Sep 12, 2011 1:13 PM (in response to Andrew Kratz)You can limit the Overview Report to do this as well.
Make a copy and set the Profile Field Name as a Query Filter on Business Unit.