Hello,
I would like to calculate a market share by country in a simple table.
Problem :
i have column 1 : Country, column 2: sum(invoice), column 3: market share by country but i it take the sum just for the country and not the sum of all of it
Page 1 / 1
Not sure what you ask, but....
In a OLAP table:
Country as Dimension
KPI= SUM(INVOICE)/GLOBAL(SUM(INVOICE)) as a percent
That will calculate for each country the percent of market share
Not sure what you ask, but....
In a OLAP table:
Country as Dimension
KPI= SUM(INVOICE)/GLOBAL(SUM(INVOICE)) as a percent
That will calculate for each country the percent of market share
oh ok perfect. I didnt notice the function GLOBAL...
Thanks you
A pleasure! 👍
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.