Hi everybody,
I need to create a BW report in the below format,
Company Code Total Total Average
0001 0002 0003 0004
Doc Type
AV 10 10 10 10 40 10
RV 20 20 20 20 80 20
Getting the report till the 'Total' column is easy but having the 'Total Average' as a separate column is where I am stuck.
Having the company code in the rows, and not clolumns, would have solved the issue but I need to keep the above format. Also I do not want to
see the Total Average for every Company Code, just that of the 'Total'.
In the Query Designer, in the Column section I have first the 'Company Code' and then the 'Count' in a structure, so whatever I add to this structure,
is displayed for each Company Code, that means 2 columns for each Company code. This changes the format.
I cannot use the Cell Definition method here, as then it would be a static structure and the number of Company Codes are not fixed.
It would be great if somebody could provide some suggestions.
Thank you,
Ajay