...
Create a performance view screen to query sales quantity/cost/amount, etc., by store and region
Goal screen |
|---|
 Image Removed Image Added
|
Step 1. Basic Practice
...
Let's create a query screen using items such as store region, store type, and sales quantity/amount.
 Image Removed Image Added
|
| Multimedia |
|---|
| name | 3. 지점별 매출실적(List)(기본).mp4 |
|---|
| width | 920 |
|---|
| autostart | true |
|---|
| height | 100% |
|---|
|
|
...
| 응용하기 | 동영상 |
|---|
- 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 |
|---|
| height | 100% |
|---|
|
|
...