I have created a table to keep a record of my share trading, it’s quite basic, just one table which perhaps is my issue. In the column called company which is “multiple select”, there are repetitions as I have bought the same shares multiple times at different prices. What I wish to do is calculate the individual company totals I hold, then calculate the percentage each company holds in my total share holdings. I can do this fairly easily on excel but would like to have a running view of the percentage each company is of my total. I would prefer to do this in the table rather than using an app if possible.
Thanks for your assistance.
This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.