cancel
Showing results for 
Search instead for 
Did you mean: 

How to define the Market Sales KF, in order to receive the desired result

Former Member
0 Kudos
124

Hi all,

I dont know how to define the Market Sales Kefigure, in order to get the following result. Any hint is more than welcome.

Prd_ID = Product ID

PS = Product Sales

M_ID = Market ID

MS = Market Sales

MS% = Market Share ( formula in BEX PS/MS)

<b>

Prd_ID;PS;M_ID;MS;MS%</b>

A00001;10;MRK1;100;10%

A00002;20;MRK1;100;20%

<b>SBTOT</b>;30;MRK1;100;30%

B00001;40;MRK2;200;20%

B00002;30;MRK2;200;15%

<b>SBTOT</b>;70;MRK2;200;35%

<b>GTOTL</b>;100;MRKX;300;33,3%

Products A00001 and A00002 compete in the same market. So the individual marketshares should be calculated against the market MRK1(200), e.g. 40/200 and 30/200.

The totals now, of the A00001 and A00002 products(3040) should be compared against <b>the same market</b> MRK1(200),</b> and <b>not against</b> the MRK1MRK1(200+200).

Thanks

Vasso Siagri<b></b><b></b><b></b>

View Entire Topic
Former Member
0 Kudos

ashwin,

thanks for your reply,

the issue here, is not how to calculate the market for each material. The problem is the sub_totals and totals.

The totals should be the sum(of unique records) based on Market_ID.

even if I have 10 products with MRK1 and 20 products with MRK2, the totalMarket should be MRK1+MRK2

and not 10MRK1 + 20MRK2.

P.S.

thanks for your info about rating. It is helpful since iam new comer in sdn.

Ashwin
Active Contributor
0 Kudos

Hi!

how are you calculating Market sales. why is it displayed as 200 instead of hundred. I think there is some mistake in the data model.

with regards

ashwin