How to use summary-level Formula to calculate percentage when a field is a specific value?
Where the percentage represents = a number of order of pizza / total orders for that month.
Jan = 2/10 orders were pizza for ID 1,
Feb = 1/10 orders were pizza for ID 2
I've already grouped my instance such that it is formatted as above. So grouped rows by Customer ID and columns by purchase month.
I tried creating a summary formula but I can't seem to figure out how to specify a specific value so that I can create the formula for summing all the order='pizza' divided by total orders.
Any help would be greatly appreciated.