How to insert a coulmn in Excel that is resulted from calculated columns in sql database
Posted on 2014-08-08
I am importing table data from SQl database in Excel by query.. however, I would like to insert additional columns in excel which are resulted from a formula done to already existing columns in the database. For instance, in SQL database I have Campaign table that consist of (AccountID, Campaign, Cost, Clicks and impressions) these columns are imported successfully to Excel. I would like to add to Excel table another column (CTR) which is equals (Clicks/impressions)
is there any way that allow me to do that?