Urgent: Market Share Calculation

[kthakur]

Hi Experts,

I need your help in calculationg Market share for below table.

Country	Subproduct	Product	Values
c01		p1	1500
c02	sp2	p2	2000
c03		p3	1800
c04	sp4	p4	3000
c05		p5	1500
c06	sp2	p6	2000
c07		p7	1800
c08	sp4	p8	3000

From above table i want to calculate top 5 products based on market shares.

Market share should be calculated on subproduct, if subproduct is not there then it should be calculated on Country.

can you please help in calculating the market share?

Thanks

Krishna

[TomMartens]

Hey,

I'm wondering if you want to create a measure or a calculated column.

How do yout want to visualize this newly calculated information, you have to be aware that it is currently not possible to mix values from different columns on an axis.

For this reason I thing it will become necessary to create an additional column, that you can use as an axis in visuals or as a row/column header in a table or matrix visual.

Please provide your expected result for a single product (if this calculation is possible), subproduct sp2 and c01.

And my final question, is there a coutry code that can be confused with a subproduct code, because both have the same value.

Regards,

Tom

[kthakur]

Hi Tom,

Thanks for responding my question. I want to create measure to calculate the market share.  The market share should be calculated at subproduct level, wherenever subproduct doesnot have the value then maket share should be calculated at country level.

I can acheive this if i have to calculate at one level either subproduct or country but how to calculate on both levels based on available values.

Please do not go by data(country id & subproduct code), this is just mockup to explin the problem, i have some other columns month,year etc to display the values the values. 

My expected result is to display top 5 products based on market share.

Thanks

Krishna

[kthakur]

Hi Experts,

Can you please help?

Thanks

Krishna