Thank you very much for your response.
However, I want to combine info, for example considering total sales of Segment 4, in GroupE in Region 4, what would be market share of each company. Therefore I put more than one dimensions in my Fixed Sales calculated camp.
Is there any way to do this?
1 of 1 people found this helpful
Here is my approach.
Because your data includes Null, Filtering Company is resulted in losing the frame work.
Instead, duplicate the data source and link only with fields in the table. But exclude "Company"
If you data has 0 on all the combination of the table, you initial approach should work.
Thank a lot Shinichiro!!
I believe this solves my issue.
You are welcome.
Could you mark my answer as correct.