Dimensional Model: Top 10 + Others in Cognos 10.1

[sujitgouda]

Guru's,

I have a relational package; I have to find Top 10 Firms + Others and show them in a list.
It works fine for with a single measure, is it possible for the others to get calculated against all measure and display the same in a single row in list.

Right now I am getting same values for all the rows,

Firm Name   Daily   MTD   YTD
Firm1                  10   20   30
Firm2                  10   20   30
Firm3                  10   20   30
Others                  70   70   70
Total                  XXXX   XXX   XXXX

I need something like this

Firm Name   Daily   MTD   YTD
Firm1                  10   20   30
Firm2                  10   20   30
Firm3                  10   20   30
Others                  70   40   10
Total                  XXX   XXX   XXX



Thanks.
Sujit

[sujitgouda]

Finally got the solution for this.

Steps:

Top 10 Field: topCount ([Firm Name], 10, [Daily])

Other: aggregate(currentMeasure within set except([Firm Name], [Top 10 Firm]))

Firms to be displayed: union([Top 10 Field],[Other])

[MDXpressor]

brilliant and elegant.  way2go neb2cog!  wouldn't have done it any other way myself.