How to calculate 'Sales share' expression: Set or Aggr?

[muujguu21]

Hi Experts - Kindly find attached my qvw file..

I have a simple monthly sales data. So, I need to calculate Manufactures share by month. I have tried with expression like =sum(Sales)/sum(Total Sales)*100, It works fine when i selected all Manufactures or Brands. But if i select 2 or 3 Brands then shares has calculated from those 3 brands.

I am sorry about my poor English. I have prepared a template with my QVW file.

[Anil_Babu_Samineni]

Looks like working. What is the issue?

[sunny_talwar]

May be you need this

Sum([Sales (L)])/Sum(Total {<Manufactures, Brands>} [Sales (L)])*100