メインコンテンツまでスキップ

logoCorrectSize.png

Workday Adaptive Planning Knowledge Center

ARCHIVEFilter Sheets

Explains how to suppress zeros and blanks and walks you through how to filter sheets by time spans, content,  and dimensions and attributes.

Filters get you to the cells you want to see and edit.

  • Filter by time in any sheet with a time span.
  • Filter by content in modeled sheets.
  • Use dimensions and attributes in cube sheets to filter rows.
  • Suppress rows that have all zeros and blanks. In cube sheets, you can then choose dimensions that reveal specific rows one at a time. 

When to Use Filters

  • To get to editable cells, reduce the size of your sheet, and eliminate scrolling.
  • To hide rows of blank data.
  • To see different sets of data if your admin has limited the amount of rows a modeled sheet can display.

Before You Begin

How You Get There

 

Filter by Dimensions and Attributes in Cube Sheets

On cube sheets, time, accounts, any custom dimensions, and attributes are dimensions. They display as: 

  • Drop-down filters above the sheet: 

Dimension filters in a cube sheet

  • Across the top of the grid in the columns.
  • Down the left side of the sheet. Multiple dimensions and attributes can nest within the rows. To pivot cube sheets, see Change Sheet View

Use the filters to:

  • Filter other filters. 
  • Filter rows. 
  • Find editable cells. You must choose a leaf-level dimension from each filter to edit data. 

Dimension and Attribute Scenario

あなたの会社は、衣類を販売する店舗です。「製品」はモデルの属性です。製品は、グループと呼ばれる属性の特性を有しています。グループは製品を分類します。個々の製品の属性は、適切な特性でタグ付けされています。製品は次のように編成されています。

グループの特性値 トップス ボトムス アクセサリー
製品属性値
  • タンクトップ
  • Tシャツ
  • ブラウス
  • セーター
  • レギンス
  • ジーンズ
  • スカート
  • ショーツ
  • ベルト
  • 帽子
  • 小銭入れ
  • 手袋

Filter Related Filters 

Often the attributes are related to custom dimension, as in the scenario described. When this is true, use the attributes to filter custom dimensions.

  1. Place accounts in the rows and time in the columns so that the attribute and its associated dimension are in the filters.
  2. Choose Tops from the Group filter, an attribute. 
  3. The available dimensions includes only those tagged with tops:  T-shirts, Tank Tops, Blouses, and Sweaters. 
  4. Choose a different attribute: Bottoms
  5. The available dimensions changes to Leggings, Jeans, Skirts, and Shorts. 

Filter filters.png 

Use Dimensions to Filter Attributes in Rows 

  1. From the toolbar, select Change Dimensions ChangeDimensions.png
  2. For Vertical, choose the attribute, Groups. Select OK.
  3. From the Products drop-down filter, select Jeans. Only Bottom remains in the rows. 
  4. From the Product drop-down filter, select T-shirts. Now, only Tops remains in the rows. 

Dimension filter attributes in rows.png

Use Attributes to Filter Dimensions in Rows 

  1. Select Change Dimensions ChangeDimensions.png
  2. For Vertical, choose the dimension, Product, and select OK. The rows include all the products.
  3. From the Group drop-down filter, choose the attribute Tops. The rows display T-shirts, Tank Tops, Sweaters, and Blouses.
  4. From the Group drop-down, choose the attribute Accessories. Now, the rows display Belts, Hats, Purses, and Gloves. 

Attributes to fitler dimensions in rows

Display Option Filters

For more filtering options:

  1. From the toolbar, select Display Options displayOptions.png.
  2. Select the tabs and select and clear any number of values. The values you clear don't appear in the sheet. 
  3. Select Apply.

Display option filters.png

  • この記事は役に立ちましたか?