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
