Skip to main content
Question

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

  • March 31, 2022
  • 3 replies
  • 13 views
A
Level 5
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

    3 replies

    G
    Level 12

    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

    A
    Level 5
    • antoine.leduc
    • Author
    • Level 5
    • March 31, 2022

    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

    G
    Level 12

    A pleasure! 👍

    Community Code of ConductAccessibility statement