Okay, thats not really a requirement just a nice feature so I will have to play with that. The next thing I'm trying to do is put the respective vendor codes as columns as well, I'm trying: case when {vendor} LIKE 'Essend Essendant Co' THEN {vendor.code} but it's not working.