4 Replies Latest reply: Jan 2, 2018 11:24 AM by vikas mahajan

Month Wise Market Share Calculation in QS

vikas mahajan Jan 2, 2018 3:06 AM

Hi all,

I have following table I wanted to calculate a month wise market share for each company wise. it should be 100 % and should not change to 100 % when I select the company

Re: Month Wise Market Share Calculation in QS

Liron Baram Jan 2, 2018 4:24 AM (in response to vikas mahajan)

hi
you can use this expression
Sum ([CY Sale])/aggr(nodistinct Sum ({<[Company]=>}[CY Sale]),MonthName)
Like Show 1 Like (1)

Actions
- Re: Month Wise Market Share Calculation in QS
  
  vikas mahajan Jan 2, 2018 11:23 AM (in response to Liron Baram )
  
  Thanks Liron it works for me !!
  
  Vikas
  
  Like Show 0 Likes (0)
  
  Actions
Re: Month Wise Market Share Calculation in QS

Sunny Talwar Jan 2, 2018 7:37 AM (in response to vikas mahajan)

Or try this

Sum([CY Sale])/Sum(TOTAL <MonthName> {<Company>} [CY Sale])
Like Show 3 Likes (3)

Actions
- Re: Month Wise Market Share Calculation in QS
  
  vikas mahajan Jan 2, 2018 11:24 AM (in response to Sunny Talwar )
  
  Thanks Sunny
  
  Like Show 0 Likes (0)
  
  Actions

Go to original post

Incoming Links

How to use getfieldSelection in Aggr