Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
Try like this
=if(Count(GetFieldSelections(FieldName))>0,Sum(Sales)*10,Sum(Sales)+10)
Hi
Try like this
=if(Count(GetFieldSelections(FieldName))>0,Sum(Sales)*10,Sum(Sales)+10)
Thank you, it works perfetct.