Sum of total Quantity for a month - Urgent

[Former Member]

Hi,

In 1 of the report we have to divide a particular key figure by the sum of quantity for a particular monnth - which will be provided by the user in selection screen.

If we view the data at various level the value of total quantity should not change. - How can we achieve this.

For e.g

deffect code no. of defects Quantity (this is the summation of quantity for given month)

101 10 350

102 20 350

103 17 350

how can we achieve the above output boldQUANTITY

Its very urgent.

[Former Member]

Problem solved by creating the local formula.

[Former Member]

Hi,

Can anyone please give some comment on this,

how can i achieve the sum of quantity for a given month in the report that should not vary with the drill-down of characteristics used in report.

ITs very urgent.

[Former Member]

Just do this.....In the keyfigure property of QUANTITY give constant selection check marked

Drilldown will not cause discrepancy with previous records

Refer this

http://help.sap.com/saphelp_nw70/helpdata/en/e7/5f983c1a356858e10000000a114084/frameset.htm

[Former Member]

Thanks SDBI,

Its a very usefule option and i got the desired result in a restricted key figure, month wise total which is constant irrespective of the drill-down chars.

But now there is again a problem as i have to derive a column according to below formula:

COL1 = No. of defects * 1000000 / Total Inspected Qty.

where :

No. of defects & Total is a key figure from the cube directly.

*Total Isnpected Qty" is again a direct key figure but is restricted for constant selection.

Now when i created the Rst. Key figure Insp. Qty and try to use that in above defined formula its not allowing me to use there.

Is it any kind of limitation, and if i want to use it then how can achieve the same ?

Its very important and urgent Issue.

[Former Member]

COL1- Create this COL in the transformation or in update rule using formula editor. So this also will be availbale in the Cube directly .Then use the formula for constant selection in the BEx

[Former Member]

SDBI,

If i create that column in cube directly and update it through end routine (which is the simplest possible option to achieve the same) then there is again the problem as the total inspected quantity will keep on changing and we have to take data of past 3 years, hence everyday or depending on the frequency i will only be able to give the full upload to the client there will be no option for delta and runnign full upload daily i think will take enough time which is not accpetable.

That's why i want to achieve the same at query level.