Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Looks like working. What is the issue?
May be you need this
Sum([Sales (L)])/Sum(Total {<Manufactures, Brands>} [Sales (L)])*100