If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Counting members in Report Studio

Started by ratnalein, 06 Aug 2013 02:34:40 AM

Previous topic - Next topic

ratnalein

Hallo everyone,

I have created a Top x report, for example Top 3 customers:

Company                         Quantity
------------------------------------------
Rabbit Company              2.000
Cat Company                      329
Bear Company                    118
Remainings                   234.870
----------------------------------------
Total                             237.317

I would like to append my report so that I got the information how many companies for the Remainings:

Company                #         Quantity
------------------------------------------
Rabbit Company     1            2.000
Cat Company          1               329
Bear Company        1               118
Remainings             142     234.870
----------------------------------------
Total                                   237.317

I am facing a difficulty to add this #-column.   I am not sure if it is possible, since my row lines are quite complicated specified:

Companies_Top:
topCount ([Companies];?Top x?;[Sum(Quantity)])

Companies_Rest:
except([Companies];[Companies (Top)])

Companies_Rest_member:
member (total(currentMeasure within set [Companies_Rest]);'Remainings';'Remainings';[Our Companies].[Customer])

For the above report, I used:

Companies_Top
Companies_Rest_member

My question:
is it still possible to build the #-column?

Thank you.

Regards,

Ratna