Hi,
I want to make a table.
I have a dataset containing sum of sales on different locations in different points of time.

The table i want to make is a table that shows the percentage sales of total sales in that given year on each location.

what i have tried to do is to devide my "sum of sales in each location in that given year" on "sum of sales on all locations" and then write

table location year (and then the variable i was telling you about above here)

what i then get is a table with a lot of 1 values and the percentages on the top of the table. i want it to show the locations to the left side of the table, year at the top and then in the table show the percentages that i know is in my dataset from the variables i have created.


do someone know how i can make this work?