Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
you can use this expression
Sum ([CY Sale])/aggr(nodistinct Sum ({<[Company]=>}[CY Sale]),MonthName)
hi
you can use this expression
Sum ([CY Sale])/aggr(nodistinct Sum ({<[Company]=>}[CY Sale]),MonthName)
Or try this
Sum([CY Sale])/Sum(TOTAL <MonthName> {<Company>} [CY Sale])
Thanks Liron it works for me !!
Vikas
Thanks Sunny