Marketshare in pivot for groups seperately calculating wrong

[louwriet]

Hi ,

I have a senario at client where they want to see their marketshare for their products in these products groups. This would now be the marketshare against competitor products.

When i say groups it means my company manufacturer for instance. Group Garden Tools - my product here would be a spade.

second Group would be for instance Lawnmowers - my product would be here Flymo 230 for instance. So what i need is to calculate my products marketshare against competittor products in that group.

My problem comes in where i have the groups in one pivot and instead of calculating the marketshares for each group out of 100% it takes all products of both groups and calculate then the product marketshare out of 100%

At the end i would like to see my two products with their marketshares within their groups.

Attached is a demo model with what i get and with picture what i actually want to achieve.

Help would really be appreciated

Louw

[JonnyPoole · Accepted solution]

here is my solution:

1. Expression formula: 

sum( VALUE)

/

sum( TOTAL <YEARMONTH,GROUP>  VALUE)

2.

a) Expression  formula:

sum( {$<MANUFACTURER={'MANUFACT_MY'}>} VALUE)

/

sum(   TOTAL <YEARMONTH,GROUP>  VALUE)

b) Replace calculated Manufacturer dimension with a regular dimension for manufacturer

[louwriet]

Hi Jonathan,

Your suggested solution worked perfectly for my senario.

Thank so much !

Louw