count distinct after accumulate

Fri, 11 Oct 2013 09:09:56 GMT

Dear All,

suppose :

count( distinct {<month = {'Jan'}>} guest ) = 10

count( distinct {<month = {'Feb'}>} guest ) = 20

count( distinct {<month = {'Mar'}>} guest ) = 15

those set of guest in different months may overlaps, thus

count( distinct {<month = {'Jan','Feb'}>} guest ) = 25

count( distinct {<month = {'Jan','Feb','Mar'}>} guest ) = 35

What i want to do is to first accumulate the guest set, then followed by a distinct count ,

if i choose Mar in selection

the report will show me 3 rows Jan, Feb, Mar...

That's it

Many Thanks!!!!

Calvin Lin

Re: count distinct after accumulate

vikasmahajan — Fri, 11 Oct 2013 09:20:05 GMT

Have try this ?

Expression : [Count of Customers]

=RangeSum( count( distinct {<month = {'Jan','Feb','Mar'}>} guest ),Above( [Count of Customers]))

Vikas