Listbox and formula in pivot table

[stark___]

Hello,

I need help.

I have two objects: listbox and pivot table.  Is it possible if I select something in listbox, my expression in pivot table will be, for example, sum(sales)*10 and if I don't select anything in my listbox, my expression will be,for example, sum(sales)+10?

Thank you, Stark

[MayilVahanan · Accepted solution]

Hi

Try like this

=if(Count(GetFieldSelections(FieldName))>0,Sum(Sales)*10,Sum(Sales)+10)

[stark___]

Thank you, it works perfetct.