Urgent: Market Share Calculation

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