# Key Figure Aggregation

Hi,

I want to avoid key figure aggregation in Bex 3.5 query designer. How to do this. It sums up and shows me a total. I want to avoid it.

Thanks

GS

10|10000 characters needed characters exceeded

### Related questions

Posted on Aug 24, 2013 at 02:15 PM

Thanks Guys

But my scenario is as below:

MAT OPERATION ORDER PLANT RESOURCE UNIT QTY 100006809 100000422478 8 KG 517 100006809 1 100000422478 8 B1153 KG 517 100006809 2 '100000422478 8 C1546 KG 517 100006809 3 '100000422478 8 B1153 KG 517 100006809 4 100000422478 8 C1546 KG 517 100006809 5 '100000422478 8 B1153 KG 517 100006809 6 '100000422478 8 C1546 KG 517

In the Query 3.5 I dont want to sum up Resource, I want to show only 2 rows

B1153 517

C1546 517

Thanks

10|10000 characters needed characters exceeded
• Gurudatta Sakhardande Anshu Lilhori

Hi Anshu,

December 15, 2013 Dec-2013 Jan-2014 Demand 39,904 38,150 16,974 Supply 27,962 42,027 32,390 Projected Inventory 25,401 29,278 44,694

Example: Projected Inventory for Dec-2013 & Jan-2014 = Prev Period Inventory + Current Period Supply - Current period demand: 29,278 = 25,401 + 42,027 - 38,150

How can i use the previous values of inventory to calculate the next on the fly in query designer 3.5

Thanks

• Posted on Aug 24, 2013 at 02:09 PM

I think what you're looking for is Exception Aggregation. It works a bit differently in 3.x than in 7.0, and I can't seem to find the documentation for it, but here's a post on how to do it:

10|10000 characters needed characters exceeded
• Thanks Shai,

I am not sure on the steps in Bex 3.5. I will go through the thread. Please let me know if you get any documentation on step by step exception aggregation in Bex 3.5

Thanks again

• Posted on Aug 24, 2013 at 08:00 AM

Hi

You can supress result rows in query designer on the infoobject you don't want to sum up.

Martin

10|10000 characters needed characters exceeded
• Posted on Aug 24, 2013 at 08:21 AM

Hi,

What you need to show instead of that...Do you need to supress the result rows ?

Regards,

AL