inverse of list box selection

[#1]

Hi all,

I have data like below and I have created List box on Brand.

Load  * inline
[Customer,Brand,Sale
A,B1,100
A,B2,30
A,B3,40
B,B1,20
B,B4,90
C,B2,35
C,B4,40
D,B4,50
];

Now if I select Brand -B1 then I want see only in either straight or pivot table who is not buying this Brand and so on for other Brands.

for Ex if I select Brand-B1 then..

Customer	Brand	Sale
C	B2	35
C	B4	40
D	B4	50

Is there any way I can do in GUI side? I don't want in script side.

Vinay

[tresesco · Accepted solution]

See the attached sample.

Expression: =Sum({<Brand=e(Brand), Customer=e({1<Brand=p(Brand)>}Customer)>}Sale)

[#3]

Great Tresesco,

Brilliant. simply superb.

I think your logic in expression is...

get the sum of sales where

1.Brand exclude Brand  then

2.Customer exclude customer but where  Brand is possible.

Please explain if I am wrong!

Regards

Vinay