I need help when it comes to working with column totals
I have a monthly job register board that we use for our incoming jobs. One column adds the “Gross Sale” and another adds the “Gross Profit”.
I would like to divide the total of the “Gross Profit” column by the total of the “Gross Sale” column to get a percentage of Gross Margin. I cant find a way to do it
Has anyone been able to work with column totals? If so please help.
Thanks in advance.