Hai

This is my query. How do I calculate market share%?

  

DEFINE FILE T1
MAKE1/A20 = IF MAKE EQ 'COMPANY1' THEN 'C1' ELSE 'C2';
END

TABLE FILE TEMP1
SUM
	QTY
BY  SEGMENT
BY  MAKE1
BY  PERIOD
END

so, I get the sum of quantities of Company1 and all others by segment, make. How do I get market share % which means for company1, I need all company1 sum of quantities divided by all other companies quantities * 100.

Thank you..

This message has been edited. Last edited by: Kerry,

got it to work..
thanks

Hi Enigma,

Glad to know it works now. Would you mind post the solution? Thank you in advance for sharing.

Cheers,

Kerry

Yes! I would be interested in this solution as well. I do the same thing in one of my procedures, but I think my code is more complicated than it needs to be, so I'm curious if there's a better way.

I used TOT.FIELD1 which created a new field with the total of FIELD1. And I used FIELD1/TOT.FIELD1 * 100 to create %


Thanks