Create a performance view screen to query sales quantity/cost/amount, etc., by store and region

Target Screen


Step 1.  Basic Practice

By using a pre-defined i-META file, you can create a list-style query screen with just the layout of query items.

Let's create a query screen using items such as store region, store type, and sales quantity/amount.


Step2.  Advanced Practice


Let's analyze the data in various ways by using features such as sorting, filtering, summing, and unit conversion on the queried data.

ApplyVideo
  1. Sorting
    : Querying data with high sales performance

  2. Filtering
    : Querying sales performance of a specific store

  3. Subtotal
    : Express subtotals by Region, SubRegion, and Store Type

  4. Layout
    : Display data by Store Type, Region, and SubRegion

  5. Unit Scale
    : Display Sales Cost in millions

  6. Calculation
    : Add a column to calculate the sales unit price