...
Create a performance view screen to query sales quantity/cost/amount, etc., by store and region
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.
|
| Multimedia |
|---|
| name | 3. 지점별 매출실적(List)(기본).mp4 |
|---|
| 위젯 연결기 |
|---|
| width | 920 | autostart | true
|---|
| url | https://www.youtube.com/watch?v=ZQRJsFvy248 |
|---|
| height | 100%600 |
|---|
|
|
...
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.
| Apply | Video |
|---|
- Sorting
: Querying data with high sales performance
- Filtering
: Querying sales performance of a specific store
- Subtotal
: Express subtotals by Region, SubRegion, and Store Type
- Layout
: Display data by Store Type, Region, and SubRegion
- Unit Scale
: Display Sales Cost in millions
- Calculation
: Add a column to calculate the sales unit price
| | Multimedia |
|---|
| name | 4. 지점별 매출실적(List)(응용)_수정2.mp4 |
|---|
| 위젯 연결기 |
|---|
| width | 650 | autostart | true
|---|
| url | https://www.youtube.com/watch?v=NvK_n9OEwCc |
|---|
| height | 100%600 |
|---|
|
|
