How to add an expression to a list box

[maxtromb]

Hi everybody,

I create a variable in a pivot table with this function:

if(sum(SCONTRINI)>=0 and sum(SCONTRINI)<2,'CASUAL',

if(sum(SCONTRINI)>=2 and sum(SCONTRINI)<6,'MEDIUM',

if(sum(SCONTRINI)>=6,'LOYAL')))

and I call it 'USE' and it works:

Now, I want to insert this variable in a list box, I want to filter with 'USE'

I try it with list box -> field -> <expression> and inserting this function:

Aggr(

if(sum(SCONTRINI)>=0 and sum(SCONTRINI)<2,'CASUAL',

if(sum(SCONTRINI)>=2 and sum(SCONTRINI)<6,'MEDIUM',

if(sum(SCONTRINI)>=6,'LOYAL'))),SCONTRINI)

I only see this:

I can select it but I don't filther anything in the other objects

[sunny_talwar · Accepted solution]

Try this

Aggr(

if(sum(SCONTRINI)>=0 and sum(SCONTRINI)<2,'CASUAL',

if(sum(SCONTRINI)>=2 and sum(SCONTRINI)<6,'MEDIUM',

if(sum(SCONTRINI)>=6,'LOYAL'))), NRO_SOCIO)

[maxtromb]

thanks a lot! it works!