Keyfigure calculation and display excluding a characteristic
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?
Edited by: Panagiotis Nikolaidis on Oct 16, 2008 1:28 PM