Hi,
I have a panel data set where i have variables "location"(where number 1 means one location, 2 another one ans so on) , "sales" numbers in dollar, and year.

i want this for example to work: total sales if location ==1 / total sales
what do i do wrong here? stata does not want to devide things if it is not variables and total sales is one value generated by summarizing all the sales and total sales if location ==1 is an estracted value(total). i want to do this for all locations.
how can i come around this?


it would be helpful if you know how to solve this problem in a table if it is possible as i would want to do it on all locations and se how big the percentage sales of each location is on the total sales of the whole dataset