I have a table of Repair Orders, and each Repair Order has a Sale Column with the total Sales for the Repair Order. What would be the best way to get a Grand Total of all the sales? Should I create a separate table with a virtual column? My end goal is to display total sales on a dashboard along with some other metrics. Any help would be greatly appreciated. Thanks!
LinkedIn
Twitter
