Formula needed to count a field and calculate the percentage of the total

811 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

0 Replies 0