count distinct after accumulate

[#1]

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

[vikasmahajan]

Have try this  ?

Expression : [Count of Customers]

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

Vikas