Top n and "ALL Other Report using Report Studio against Cube

[CognosChas15]

 ???

Is there a way to create Top n Report with "All Other" Column in Report Studio using a Cognos Cube,  we are on version 8.2 of Report Studio and 7.3 of Transformer. 

Thanks

Charlie

[rockytopmark]

For the Top N, use the TopCount() function.  Then, in another expression, I'm sure you can return an aggregate of all the members that are NOT IN the TopCount() expression

[MFGF]

Hi,

Mark's absolutely correct here.  The other expression he refers to would need to use the _remainderSet() function.

Best regards,

MF.

[CognosChas15]

Thank you both for your Replies,  I had the first part done  Top Count, just did not know how to get the rest... Thanks Again!!!  I will give it a try and let you know the results 

Charlie