Skip to main content


Workday Adaptive Planning Knowledge Center

Change Sheet View

Explains how to change your view of sheets using Display Options and other tools.

The default view of the your sheet is set by your admin. You can pivot the sheet and use filters to get to the data you want to see. You can also save your own initial view. Choose from these options to change your view of sheets:

  • Swap the rows and filters.
  • Change dimensions and coordinates in cube sheets.
  • Reset the display options.

See Filter Sheets to learn how to filter out data in modeled sheets, and suppress zeros and blank rows in all sheets.

Before You Begin

How You Get There

Compass.png From the nav menu select Sheets, Assumptions, or Processes. Once you open a sheet, select a version and choose a level. You must choose a leaf level to edit cells.

See Open Sheets and Get to Editable Cells.

Your Saved View and the Default View

The default view and your saved view are different. Your admin sets the default view for all users. You can save your own preferred view anytime you change the view and save the sheet. When you return to the same sheet and version, you see the filters, rows, columns, and dimensions you saved. 

Select Reset to Default View from the toolbar to return to the default view your admin created.

Swap Rows and Filter in Standard Sheets

Watch the video: (34s)

Pivot Standard Sheets

When accounts are down the rows, right-click in the first column, and select View by level. The levels display down the rows and you can filter the accounts. To switch back, right-click in the first column and select View by Account

Change Dimensions and Coordinates in Cube Sheets

Watch the video: (1m)

Pivot Cube Sheets

Swap the Columns and Rows

From the toolbar, select Swap Columns and Rows to swap the current rows with the current columns. For example, if you have time across the columns and accounts down the rows, select this button to display accounts across and time down the rows.

Drag and Drop Filters into Columns and Rows

You can swap any dimension or attribute filter in cube sheets to the columns or rows. 

Dimensions and attributes are built into cube sheets by your modeling admin.

Drag a dimension or attribute from the top of the sheet. Wait until the cell turns blue, then drop into:

  • The first column of any row to replace the current row dimension. Or if there's nested dimensions in the rows, drop it on the one you want to replace.
  • The header row of any column to replace the column dimension. 

Drag and drop and dimension into the rows.

Use the Change Dimensions Button

Change Dimensions in the toolbar lets you manage the columns, rows, and filters all at once.

  1. From the toolbar select Change Dimensions. On the left side, choose your columns and rows. On the right, select your filters. As you select dimensions for the columns and rows, they become unavailable in the Filters section. 
  2. From the Columns drop-down, choose one dimension or attribute. 
  3. From the first Rows drop-down, choose one dimension or attribute.
  4. (Optional) Choose more dimensions in the additional row drop-downs. These nest within the dimension above it.
  5. For the filters, select the values from each available dimension to filter the sheet. 
  6. Select OK

Revert to Your Admin's Default View

To revert back to the default view set by your admin, select Reset to Default View and then Save from the toolbar.

  • Was this article helpful?