Crystal report 2 columns values

[LBC2]

My table is as follows
Sales|VendorNb|EmployeeNb|
I created a report showing sales by employee Nb if vendor Number is 11111.
Now I would like to modify my report to have 2 columns:
1 Column showing sales from vendor 11111
1 Column showing sales from other vendor items.

For example,
Employee Number
Total Sale Vendor 11111 Total Sales Others Vendors

Anybody would have a sample or some hint because I am having difficulty to do it using a sub report.
Thanks
Louis

( I am using Crystal XI)

 

[AndyMc]

Create two formulas side-by-side that you would sum by employee:

{@111111}
if {your VendorNb field} = "111111" then {your Sales field} else 0

{@not111111}
if {your VendorNb field} = "111111" then 0 else {your Sales field}

 

[LBC2]

Perfect.
thanks