How to calculate 'Sales share' expression: Set or Aggr?
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.