Skip to Content
0
Former Member
Mar 11, 2009 at 11:23 PM

Exception Aggregation

16 Views

Hi,

I have the following dataset in my query.

Material Country Inventory Weeks

1234 US 5

1234 UK 10

1234 BE 15

When I remove Country as a drilldwon this is what is shown

Material Inventory Weeks

1234 30

What I want is:

Material Inventory Weeks

1234 10 (Average of all the Country Value)

I could set the exception aggregation to Average and have the reference characteristic as COUNTRY, but I can't change the KF as is is used in multiple places. Is there a way I can accomplish this at the query level. I tried Calcualte Single Values as 'Average' but it doesn't seem to change things.

Thanks in advance.

Rgds

Anand