Note:
I have found a trick to get around this for any users who have not upgraded from 10.6. Select the "Switch Row/Column" button under the cartesian menu then unselect it.
Hi Mathew,This is a bug that's been identified in version 10.6 and has been fixed from version 10.7.0.0.47139. I would suggest you to upgrade to version 10.8 as this is last upgraded version in 10 with upgrades and fixes from previous versions.
Thanks & Regards,Samson.