Total Sales in a Block chart

[sunainapawar]

Hello,

We need to calculate the Market Share Percentage of one company with respect to other companies in Block chart. I used the below expression but its not working fine.

sum(sales)/sum(total sales)

I also tried using ALL instead of total, but that is also not working. 

Please help to suggest any solution. Thanks in advance. 

[lorenzoconforti]

Can you post your qvf or an example to understand better the requirement? Or maybe even some screenshots

[sunainapawar]

Hi,

Yes , i have attached the screenshot.  We need to calculate the Market Share of each companies with all other companies.i., sales of each company/total sales of each companies. I also tried the below expression,it dint work.

sum(sales)/sum({<company_name={"*"}>}total sales).

We also tried to aggregated it by Fyear, it dint work.

sum(sales)/aggr(sum(sales),Fyear))

Please help. Thanks in advance.

[lorenzoconforti]

I'm guessing the sum of the percentages is not equal to 100%?

What if you try to create a simple table just to check your calculation is working correctly?

One dimension (company) and 3 measures (sum sales, sum total sales and percentage)