Forum Discussion
Helper IUrgent: Market Share Calculation
Super UserHey,
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
kthakurHi 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