Skip to Content
0
Former Member
Apr 28, 2014 at 08:53 AM

BEx Query Formating - Displaying both Sum and Average in the same report

420 Views

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