Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See the attached sample.
Expression: =Sum({<Brand=e(Brand), Customer=e({1<Brand=p(Brand)>}Customer)>}Sale)
See the attached sample.
Expression: =Sum({<Brand=e(Brand), Customer=e({1<Brand=p(Brand)>}Customer)>}Sale)
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