COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: yvswamy on 05 Apr 2013 03:48:06 AM

Title: How to get the TOP5 Customers Total in a Data Item
Post by: yvswamy on 05 Apr 2013 03:48:06 AM
Hi All,

How to get the TOP5 Customers Total in a Data Item expression.

Regards,
yvswamy
Title: Re: How to get the TOP5 Customers Total in a Data Item
Post by: blom0344 on 05 Apr 2013 04:31:01 AM
Do a search on rank / top on the forum. There must be tens of posts regarding this question..
Title: Re: How to get the TOP5 Customers Total in a Data Item
Post by: yvswamy on 05 Apr 2013 04:36:48 AM
At Query level I am able to get the TOP5 Customer. But not in a Data Item Expression. I want the Top 5 Customers total in a Data Item expression.
Title: Re: How to get the TOP5 Customers Total in a Data Item
Post by: blom0344 on 05 Apr 2013 07:53:16 AM
A data item expression is just part of the query definition. To put it more exactly : the definitions of all the dataitems combined with the model they come from (relationships etc) build the query.