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,