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

Roll-up number List Report

Started by peewan, 24 Mar 2020 12:29:11 PM

Previous topic - Next topic

peewan

I doing List Report
Relation

Member Name
Number Group = Count(Distinct [Group#]) for Member ID, detail&summary aggregation - None

Product 1= case when [Product ID]= 1 then [Member ID], Detail aggregation - count distinct, summary Defalt
Product 2= case when [Product ID]= 2 then [Member ID], Detail aggregation - count distinct, summary Defalt
Product 3= case when [Product ID]= 3 then [Member ID], Detail aggregation - count distinct, summary Defalt

Please see attachment.

I would like all my number roll up total for each member.
How would i do that.
Thank you,