2 of 2 people found this helpful
I now have a work around to the problem and can produce an accurate csv file with 2 measures in it by using a bullet chart as the source of the export. Don't ask me why it works, but it does.
Another issue I have come across though is a difference in the character set used in the csv file when exporting via tabcmd as opposed to the normal server web interface. Users are accessing the csv files with excel and this interprets the character set of the csv file as Windows ANSI. This works fine for the web based export but produces weird and wonderful currency symbols (it effects euro & pound symbols but not dollar) using the tabcmd export. It seems that it can be made to work but you need to invoke the import wizard in excel and pick up a UTF-8 character set.
It would be great to have these csv exports being handled in a consistent manner as users are largely unwilling or incapable of jumping through these hoops.
If anyone has an idea how I might fix this I would be very pleased to hear from them.