PivotTable : Create a PivotTable which can show whether the distribution of orders for fruit vs vegetable products differs across the 7 sales regions.

PivotTable Create a PivotTable which can show whether the distribution of orders for fruit vs vegetable products differs across the 7 sales regions. Modify your table using “Show Values as” so that you can meaningfully compare the split between categories across regions which have different subtotals. Recode the “Category Recode” column in the spreadsheet to … Read more