Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to display in a chart dimension that repeat values over 3 times.
I try to solve my problem using "if" but and sum result but there is an error in expression.
Dimension of chart: [BUSINESS UNIT]
Expression
sum(AGGR(IF(Count ({(<[RAPP NDG] ={'*'}>) + ( <[RAPP COI] ={'*'}>) } DISTINCT [COSTUMER])>3, 1,0),[COSTUMER]))
I think that I need to solve problem with set analysis.
Perhaps like this:
count({< [BUSINESS UNIT] ={"=count({<[RAPP NDG] ={'*'}>+<[RAPP COI] ={'*'}>} DISTINCT [CUSTOMER])>3"} >} [BUSINESS UNIT])
I try it. It's ok! Thanks a lot!