Grouping data

[#1]

Hi

I have to create a graph that shows the number of campaigns received by the customer base in a month.

on x axis it would be the number of campaigns 1, 2,.....10+

on y it should be the customer base.. 5%,10%,15%....100%

This should show what percentage of the base receives 1,2...10+ campaigns

Data I have is mobile number, campaign code, date.

I did the count(campaign code) against the mobile which gives me the campaigns received for each mobile, how would i group this mobile base?

Thanks

[swuehl]

Mobile number denotes your customer?

You can try a calculated dimension like

=Aggr( Count([Campaign Code]), [Mobile Number])

and then use

=Count(DISTINCT [Mobile Number])

or

=Num(Count(DISTINCT [Mobile Number]) / Count(DISTINCT TOTAL [Mobile Number]),'#.00%','.',',')

for a percentage.