Skip to Content

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

Logic for reporting

Experts,

I need your help in achiving the following in my query.

Scenario:

I have SALES, UNITS, PH2 and CALMONTH coming from the Cube.

CALMONTH PH2 SALES UNIT

10/2008 0110 20 10

10/2008 0110 30 10

Result(By PH2) 50 20

10/2008 0111 35 25

10/2008 0111 30 10

Result(By PH2) 65 35

What I need to Achieve is divide total SALES / total UNITS by PH2 and save it in another column as below

CALMONTH PH2 SALES UNIT AVG

10/2008 0110 20 10 2.5 (50/20)

10/2008 0110 30 10 2.5

Result(By PH2) 50 20 2.5

10/2008 0111 35 25 1.871(65/35)

10/2008 0111 30 10 1.871

Result(By PH2) 65 35 1.871

Can you please give some inputs on how I can achieve this.

Thanks

Raj

replied

Hi Raj,

Good to know it helped.Have u can tried the same with SUMRT and SUMGT. Not sure whether it will give the desired result.

Regards,

Rathy

0 View this answer in context

Helpful Answer

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