Dear all,

I am currently working with a dataset that contains information on quarterly gross value added of different economic sectors for several countries. I calculated the sectoral shares of gross value added for each country. Now I am trying to create a table that displays the the sum of gross value added for each country and the shares of the respective sector. I have no experience with creating tables in Stata. What I tried is the tabulate function with country and sector. It shows me the number of observations, but what I am trying to show is the observation value, as well as the sectoral share of the sum of all values.

Does anyone have an advice what I can do to get my desired outcome?

I would highly appreciate any kind of help. Thank you in advance!




. tabulate country sector

| Sector
Country | AGR CON IND SER | Total
-----------+--------------------------------------------+----------
DEU | 10 10 10 10 | 40
ESP | 10 10 10 10 | 40
FRA | 10 10 10 10 | 40
ITA | 10 10 10 10 | 40
-----------+--------------------------------------------+----------
Total | 40 40 40 40 | 160