HelpCenter

Explore
Avanti - Product Pricing by Location Report - Formatting and Analysis
Updated

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 the AMS Reports.

Login to AMS and download the Product Pricing by Location report:

mceclip0.png

Open the downloaded CSV file and perform the following steps:

mceclip1.png

mceclip2.png Select all columns in the report

mceclip3.png Go to the Insert tab

mceclip4.png Select Pivot Table

mceclip5.png

Now you can easily compare prices by locations.

mceclip7.png

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:

mceclip8.png

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.