Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thanks! This did the job! Now the calculation is made on current selection, but for supplier where it includes all.