Current selection but include all for one field in Set Analysis

[annabergendal]

Hi,

I feel quite stupid, I am sure this is piece of cake...

I have a straight table where I want average sum of sales for each supplier.

So for supplier A it should say 0,14 (100/700), supplier B 0,29 (200/700) etc...

How should I write my set analysis expression if I want current selection (in the real app I want selections to be included, except for the field supplier where it should calculate on all)

Thanks

[annabergendal]

Thanks! This did the job! Now the calculation is made on current selection, but for supplier where it includes all.