Skip to Content
Former Member
Jul 07, 2006 at 04:50 AM

How to get the Overall result and Avg in Query



I am facing a problem to find Overall result and Avg for the keyfigure.

Here is the scenario.

I have a fiscalperiod ,qty in query column and material in row, when user enters the fiscalperiod(004.2006 to 006.2006)

the output should come as

0406 0506 0606 Avg

M1 10 20 40 35

M2 20 40 30 45

res 30 60 70

i can able to get the overall result not avg,

if i change the properities of keyfigure 'Calicuate Result as 'Average of all values'',then i am loosing the overall result.

eitherway i can able to get one result,not both.

anybody can help.