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

List report - Count on group

Started by AppsD, 24 May 2010 04:43:44 AM

Previous topic - Next topic

AppsD

Hi All,

We have one request as follows..

1. We have list report as shown below

Trans ID      Cust name   Rule Key     Rule Count

1111              A                 09099
                                        09098        2

1119              B                090876
                                      090875       3
                                      090888

1117              C                 09099
                                        09098        2

1118              D                 09000
                                        09001       2


Count gives how many rules (there is no limit for rules) are applied on single transaction.

2. Now we have to check how many time SET OF Rules is repeating in the Report

For above ex. new report will show as

For rule count = 2

Rule key           count
    09099
    09098            2

     09000            1
     09001 

And similary for Rule count = 3.

Could you please share yours thoughts - how to achieve this?

Thanks!