I have made 2 tables, one a sheet listing all of my trades, and a second table with just basic statistical info on stocks I've traded (avg daily volume, market cap, etc). What I would like to do is add a column TOTAL P/L on the second table which will sum up my p/l for each stock that I have traded. First, is it possible to use a calculated field in my second table based on multiple entries in the first table? (I'm guessing it's not possible). If I need to instead use a query, how would I go about writing an expression which will find each trade for a given stock in table 1, sum up the P/L, and return the value into a single field for each stock in table 2? All replies appreciated.
Ok sry I just stumbled on the answer using the query wizard, where they ask in the end whether you want to show each record or just a summary. I chose summary and SUM of p/l grouped by each stock.