Nested Set Analysis - New

[ashish_2511]

Dear Community

I know this topic has been discussed a lot but I couldn't find anything relevant to my problem. So here's my problem

I have to write a pivot table  expression like this -

Count(Distinct {<only({<$(vServTarg_ExcludeSelections)>}MTM_COUNTER)=1,
Sum({<BV_DETAIL_LATEST_FLAG={1}, $(vServTarg_ExcludeSelections)>}BV_D_COUNTER)=0,
Sum({<YM_ACTI={$(vMonth0),$(vMonth1),$(vMonth2),$(vMonth3),$(vMonth4),$(vMonth5)}, ACTIVITY_SERVICE_TYPE = {'HT', 'LT'}>}ACTIVITY_COUNTER)>0 >}
CONTACT_ID)

Unfortunately it won't work. Also I cannot write it using 'If' as it won't allow nested aggregation.

Please suggest.

Thanks in advance

Sneh

[jyothish8807]

Try like this then,

count(distinct If([MTM_COUNTER]=1 and Sum({<BV_DETAIL_LATEST_FLAG={1}>}BV_D_COUNTER)=0 and Sum({<ACTIVITY_SERVICE_TYPE = {'HT', 'LT'}>}ACTIVITY_COUNTER)>0,[Contact ID]))

Br,

KC

[ashish_2511]

Fantastic! this is what I was looking for. A small problem though - I've calculated dimensions . do you have something else that would work with calculate dimensions?

Thanks for all the help so far

Cheers!

Sneh

[ashish_2511]

Thanks for that. I'm afraid this isn't working as nested aggregation is not possible in 'If' but having a aggr function around will make it work as Jonathan suggested above.

Thanks!

[sunny_talwar]

May be you can perform the calculated dimension's calculation in the script?

[gloria_bertini]

Hi,

i don't know if it can be useful for you case, but maybe you can try syntax for nested set analys like proposed in this thread

set-analysis lost customers

regards