Average of all key figures

[P2006927273]

Hi All,

I need to develop a query which has to get the Average values based on 3 characteristics Month, Region and Platform.

Layout is as in the attached file

Please guide me how can achieve this in bex query.

Regards,

Vijay

[Former Member · Accepted solution]

It can be achieved using "Calculate result row as" of Keyfigure peoperty.

Just make result row as always display for all 3 characteristics and then go to property of KF for which you need average. goto calculations --> specify average in "Calclate result value as" and it will work

steps:

1. change display property of Region, Platform and Month as Result rows:"Always Display"

2. go to Calculation tab of all Key figures where you want to average as result.

3. change calculate result row as to: "Average" for  all KFs where average is required

Regards,

Dipti

[P2006927273 · Accepted solution]

Hi Dipti,

Thank you so much and the way you imagine of the options w.r.t requiement is excellent.

Regards,

Vijay

[Former Member]

Hi Vijay,

It is not possible to calculate average based on 3 different info objects. But the alternative solution would be have Mandatory single value filter on 2 of the 3 info objects and define exception aggregation as Average on 3rd Infoobject.

Thanks,

Reshma M.

[former_member182343]

HI Vijay,

Consider most granular charecterstic out of those 3 chars (in your case it seems Machine) and take that charecterstic as reference for exceptional aggregation - Average.

Regards.

[P2006927273]

Thank you for reply.

You are right avg. w.r.t one character is possible.

Is there any way of doing for more than one character for all keyfigures ??

Thanks in advance..

Vijay

[Former Member]

Hi Vijay,

I guess no its not possible in Bex.

Thanks

Aakash

[Former Member]

Hi Vijay,

We can achieve average of keyfigure based on 1 reference characteristic using Exceptional aggregation.

If you want to calculate average based on any one of the above characteristics as reference then you can check with Exceptional aggregation.

Thanks

Aakash

[ravi_chandra3]

Hi vijay,,

Use excpetion aggregation as average and the aggregation as average,

and reference characteristic as month,