The file named Problem26data.xlsx gives sales information for a department store chain. The tax rate for each

Question:

The file named Problem26data.xlsx gives sales information for a department store chain. The tax rate for each state is given, and no tax is paid on non-profit sales. Create a PivotTable that shows the amount of tax paid on sales of each product group in each state, and create slicers that will make it easier to filter your PivotTable.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: