Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Keyfigure calculation and display excluding a characteristic

Hi Gurus,

I hope you can help me with the following scenario.

I have a query that displays quantities and values per customer code and material code. I need to create a new keyfigure in my query that is going to display the average price calculated using the total value and quantity per material code.

This average price should be shown in every line of my report meaning that i want to have an analysis per customer and material and the columns should include Quantity and value for the customer+material combination and the total average price of the material code.

In other words can i sum up the quantities and values per material code and this to be diplayed in every customer-material combination?

Is this possible in query design or should i restructure my data in the infocube?

Thanks=points

Panos

Edited by: Panagiotis Nikolaidis on Oct 16, 2008 1:28 PM

Former Member
Not what you were looking for? View more on this topic or Ask a question