I need to transform a large Excel-file (small part of it is attached for structure). I read the file to a QV app today, but need to add column Q as Total under Version. Total is the same value as Dec (Month).
Client need to use Version as part of a bar chart with Product as legend and 'Per. mål' (Goal), Utfall (Result) and Total as bars. (Three bars per product...)
Version has to be: 'Per. mål', Utfall and Total
Data for 'Per. mål' and Utfall is under Belopp (Amount) so data for Total has to be added to Belopp as well. Can you do this without rebuilding the entire Excel-file?
They need to be able to select on month (Månad). In this case we have only a relation to Total when Dec is choosen or no month at all. Maybe one have to read the column Total instead and add that to Belopp (Amount). Total must be available no matter which month they choose...
The export will use the operating system libraries, meaning that if you have installed, for example, Office 2003, the result will be .XLS (BIFF) files. But if you have installed Office 2007 or 2010 the resulting file will be .XLSX (OOXML) by default.
Are you just right clicking and selecting export or using a macro or an action?