Market Share Calculation using Set Analysis

[#1]

Hello All,

I am trying to calculate sum(sales) of current brand selection and divide it by sum(Sales) for the associated market.

Not sure how to calculate overall sales for a specific market as only Brand is selected( market is not selected) .

i am trying to calculate it as sum(Sales)/ sum(total<Market>sales) where denominator gives me total market value whereas i need to calculate it only for associated market value for the brand selected

[agomes1971]

Hi,

please see attached

HTH

André Gomes

[#3]

Sorry, but i use the personal edition

[agomes1971]

Hi,

so how do you want me to help you?

Regards

André Gomes

[rubenmarin]

Hi, can you try if this expression can work for you?:

sum(Value)/sum(total<Market> {<Brand>} Value)

This can work on a table with Brand as dimension, so that dimension filters the market.

Yyu can test in the straight table, for a row with Brand it will be correct, but the total row will sum all the brands in all the the markets, this is because there is no brand filtering.

[#6]

Hello Ruben,

the expression doesnt work. on selection of year , month and Brand (IN01). i want to calculate sum(sales) for IN01 / sum(sales) for Indigo Market only.

your expression gives me the value for all markets. I want to calculate for the associated market for IN01 only

[#7]

Hi Andre,

I have tried several expressions, but couldnt get through. Just need a suggestion on how do i write the  expression for associated value which isnt selected? I want to select only Brand and not market. Just the market associated to the brand should be calculated as sum(sales) for that market.

[#8]

Hi Adity,

Try this expression :

sum(TOTAL {$<Market = P({1<Brand={'$(=GetFieldSelections(Brand))'}>}),Brand>} Value )

thanks

Sovan

[Gysbert_Wassenaar · Accepted solution]

Try: sum(Value) / sum({<Brand=,Market=p(Market)>} Value)

[#10]

Thanks a lot. It worked. could you please explain me the expression.