help in creating a table

[Yusra Noorwali]

I have a panel data of investments with these variables : 1) investment amount 2) investment year 3) investment tech (dummy variable 0,1)

I want to create a table that shows the total amounts of all investments in a particular year for investment tech =1 and the same for investment tech =0

can anyone help me how I can do this in state?

[Carlo Lazzaro]

Yusra:
see -table- and/or provide more details. Thanks.

[Attaullah Shah]

See this post where I show the use if i. prefix for categorical variables (I think the investment variable in your data is categorical)
https://www.statalist.org/forums/for...-using-outreg2