Set analysis nested

[agigliotti]

Hello,

I have the following expression in a straight table:

count( {< _FATTURATOFlag = {"S"}, [Anno fattura] = {"$(vAPP)"}, [MMGG fattura] = {">=$(vMMGGdal)<=$(vMMGGal)"},

[Codice cliente] = {'=sum( {< _FATTURATOFlag = {"S"}, [Anno fattura] = {"$(vAPP)"}, [MMGG fattura] = {">=$(vMMGGdal)<=$(vMMGGal)"} >} [Importo netto riga] )>0'}

>} DISTINCT [Codice cliente])

with a dimension named "Wine type".

I need to count the customers ([Codice cliente]) with Sum([Importo netto riga]) > 0 for each dimension value (Wine type).

I noted it's working fine only if I select a single dimension value, else I get a number greater than the correct one.

Can somenone help me to achieve it?

Many thanks in advance.

Best Regards

Andrea

[agigliotti]

It's working well !!!

Thank you very much for your help.

Best Regards

Andrea