Understanding how your products are priced across different markets is critical to running a successful business. If you're unfamiliar with our reporting system, check out this article!
Login to AMS and download the Product Pricing by Location report:
Open the downloaded CSV file and perform the following steps:
Select all columns in the report
Go to the Insert tab
Select Pivot Table
Now you can easily compare prices by locations.
However, if you still want the format as in the previous days - Product in the rows and Locations across the top - match your pivot table settings to these:
If you ever get lost, just start again from scratch. It will likely be easier to generate a new report and try again rather than sifting through excel to fix problems.