Avanti - Product Pricing by Location Report - Formatting and Analysis

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:


mceclip2.png Select all columns in the report

mceclip3.png Go to the Insert tab

mceclip4.png 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.