There is a matrix box that shows normal sales amount and special sales amounts by customers as follows:
Customer Normal Sales Special Sales Total Sales Special Sales %
a 1020 45 1065 4%
b 130 45 175 26%
c 45 100 145 69%
I can easly create Normal Sales, Special Sales and total of those two but I cannot calculate the percentage of special sales to the total sales. What should I do?
View Complete Post