...
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% |
---|
|
|
...