페이지 트리

버전 비교

  • 이 줄이 추가되었습니다.
  • 이 줄이 삭제되었습니다.
  • 서식이 변경되었습니다.

...

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

Goal screenTarget Screen

Image RemovedImage Added


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.

Image RemovedImage Added

Multimedia
name3. 지점별 매출실적(List)(기본).mp4
위젯 연결기
true
width920autostart
urlhttps://www.youtube.com/watch?v=ZQRJsFvy248
height100%600


Step 2Step2.  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.

  1. Add a column to calculate the sales unit price
응용하기Apply동영상Video
  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
    : 매출단가 계산 컬럼 추가하기
Multimedia
name4. 지점별 매출실적(List)(응용)_수정2.mp4

위젯 연결기
true
width650autostart
urlhttps://www.youtube.com/watch?v=NvK_n9OEwCc
height100%600