Hi Everyone!
i have a specific requirement to produce a comma delimited file which has total row calculated at the top of the report. since rest of the columns are blank for the very first (total) row, i am getting only commas -- which is understandable HOWEVER my legacy backend application does not like those extra commas. Anyone come across this type of situation. Trying my luck with this awesome community before i make changes to the receiver.
@DharmaAcharya
I am not sure your attached the correct one.
I have made some dummy data and hope it can give some hint.
@DharmaAcharya One of the options I am thinking to use the Python tool to manipulate the final output file, something like the one below, I would defer it with @PhilipMannering , who one of the expertise in python tool
