Use If()+ Accumulative+ Count Distinct

[CanCan]

Hi Experts,

I am trying to create an accumulative chart with some IF conditions but the result is not accumulated properly. 

My formula:

IF('$(vProduct)'='A',rangesum(above(Count(distinct {<[Product Type]={‘A’}>} Customer ID)),0,rowno()),

IF('$(vProduct)'=’B’,rangesum(above(Count(distinct {<[ Product Type]={‘B’ }>}customer ID)),0,rowno()),

IF('$(vProduct)'='C',rangesum(above(Count(distinct {<[ Product Type]={'C'}>}customer ID)),0,RowNo()),

               IF('$(vProduct)'='ALL',rangesum(above(count(distinct(customer ID))))))))

My result will be something like below if i use above expression.😢

Appreciate if you could enlighten me.

Thanks!

[sidhiq91]

@CanCan  Can you please provide some sample data?

[MayilVahanan · Accepted solution]

Hi

$(vProduct) -- is selected by user in filters? ie. At a time, one if condition will be executed? 

Try like below

=rangesum(above(IF('$(vProduct)'='A',Count(distinct {<[Product Type]={‘A’}>} Customer ID),

IF('$(vProduct)'=’B’,Count(distinct {<[ Product Type]={‘B’ }>}customer ID),

IF('$(vProduct)'='C', Count(distinct {<[ Product Type]={'C'}>}customer ID),

                IF('$(vProduct)'='ALL',count(distinct(customer ID)))))),0,rowno(Total)))

[CanCan]

@MayilVahanan  Thanks for the big help!!!!! It worked!!!!!😊 

[MayilVahanan]

Hi

Happy to know that, Can you please close the thread?