This content has been marked as final. Show 5 replies
I'm working on app where I'm suppose to display a table 3 columns
promotion category, number of sales for category and percentage of sales for each category (This will add to 100% for all categories.).
There could be sales that does not belong to any of the promotion categories. There are additional filters to fileter on year, month, region etc.
I was not able to write formula to calculate percentage of sales for each category. Please advice me on this.