Hi,
I have the following columns and the situation.
Total Customers: (Count distinct of cust no)
channel Values below
Internet = 1 , null
branch = 1, null
mobile = 1, null
my report is
1) month, total customers
201510 7000000
when i run another report with Channel Type (case statement) with Month and Total Customers
case statement for channel type column
case when internet =1 then internet
when branch =1 then branch
mobile =1 then mobile
else others end
2) month channel type total customers
201510 internet 3600000
201510 branch 2800000
201510 mobile 600000
3) but if i choose total customers where branch =1 then it is giving 4400000, as the 2nd report is giving unique customers of each channel
where as the 3 rd report gives the customers who use branch channel, these customers might also use Internet and mobile
if i want to get 4400000 for branch channels, how can i do this. if i choose the channel type attribute the column count the customers only once in any of the channel. but i want to count each customer once if customer use 3 channels.
please let me know any ideas.
