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:
- 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
Your business is a store that sells clothes. "Products" is a dimension in your model. Products has a dimension attribute, called Group. Group categorizes the products. Each product dimension is tagged with the appropriate attribute. The products are organized like this:
|Group Attribute Values||Tops||Bottoms||Accessories|
|Product Dimension Values||
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.
- Place accounts in the rows and time in the columns so that the attribute and its associated dimension are in the filters.
- Choose Tops from the Group filter, an attribute.
- The available dimensions includes only those tagged with tops: T-shirts, Tank Tops, Blouses, and Sweaters.
- Choose a different attribute: Bottoms.
- The available dimensions changes to Leggings, Jeans, Skirts, and Shorts.
Use Dimensions to Filter Attributes in Rows
- From the toolbar, select Change Dimensions .
- For Vertical, choose the attribute, Groups. Select OK.
- From the Products drop-down filter, select Jeans. Only Bottom remains in the rows.
- From the Product drop-down filter, select T-shirts. Now, only Tops remains in the rows.
Use Attributes to Filter Dimensions in Rows
- Select Change Dimensions .
- For Vertical, choose the dimension, Product, and select OK. The rows include all the products.
- From the Group drop-down filter, choose the attribute Tops. The rows display T-shirts, Tank Tops, Sweaters, and Blouses.
- From the Group drop-down, choose the attribute Accessories. Now, the rows display Belts, Hats, Purses, and Gloves.
Display Option Filters
For more filtering options:
- From the toolbar, select Display Options .
- Select the tabs and select and clear any number of values. The values you clear don't appear in the sheet.
- Select Apply.