Skip to Content
0
Former Member
Dec 15, 2006 at 04:41 PM

How to get two Results - Sum and Average for one KeyFigure

27 Views

I have "Material" in Rows and "Cal Year/Month" in Columns and also KeyFigure "Qty" in Columns.

The Results (Yellow) of "Qty" is defined as "Avg of all values <>0". This works fine but how do I get two Results - one is a "Sum" and the other "Avg" for just one KeyFigure. The output basically should look like below:

Cal Yr/Month 01/2006 02/2006 03/2006... Result Result

Material Qty Qty Qty Sum of Qty Avg of Qty

ABC 100 0 200 300 150

DEF 100 200 300 600 200

GHI 500 300 400 1200 400