Skip to Content

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

How to calculate % based on totals of a characteristic

HI BI query goeroes,

I have following query:

Sales org - S&OP - Channel - PSI - KeyFigure1 - % S&OPKF1 - % Channel KF1

S100--


S
A

A
---10
10/60
--


10/30

S100--


S
A

B
---20
20/60
--


20/30

-


total ChannelA--


30

S100--


S
B

A
---15
15/60
--


15/30

S100--


S
B

B
---15
15/60
--


15/30

-


total ChannelA--


30

total S&OP S 60

Question is how to calculate the last two colums.

First colum should calculate the Keyfigure1 percentage based on the overall total of S&OP per salesorg (keep in mind that we have multiple sales orgs).

Last colum should calculate the Keyfigure1 percentage based on the total of Channel per salesorg/s&op group.

Can anyone please assist me how to do this?

I am using the BI7.0 query designer.

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