Custom Column to work out the Percentage of another column
Can I please have some help on a custom column? I have read posts simular to mine but I am unable to get it to work.
I have a table for days of the week, (Mon to Sun), I used a custom column to count the total amount of orders per weekday from another table. I would like the next column to show what percentage of orders we get on what day of the week but I am unable to work out how to do it.
This is my current table, the last column is what I would like it to show. Can I please have some assistance with the code?
Percentage of orders over a week
I need the data in a table to be able to use it the way I want to later.