stevehamby
MIS
Just wondering... is there any way of doing a top 10 funtion in Impromptu? e.g. from a list of 100 products return the top 10 best sellers
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Top functionality in Imp 6
- Thread starter stevehamby
- Start date
- Status
Steve,
The rank function can be used together with a count of total grouped attributes to return the top 10% of any measured grouping.
Regards,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"![[pc2]](/data/assets/smilies/pc2.gif "[pc2] [pc2]")
Want good answers? Read FAQ20-2863 first!
The rank function can be used together with a count of total grouped attributes to return the top 10% of any measured grouping.
Regards,
Dave Griffin
The Decision Support Group
Reporting Consulting with Cognos BI Tools
"Magic with Data"
Want good answers? Read FAQ20-2863 first!
- Status
Similar threads
- Locked
- Question
- Locked
- Question