Rearranging Dimensions along Filter, Columns and Rows
You can move Dimensions along the Filter, Columns and Rows to achieve a desired VIP sheets Slice view.
To reconfigure a view:
1. With a Google VIP sheet Slice—e.g., the default Slice shown in the following image—go to the VIP sheets pane (located on the right-hand side).You will arrange Dimensions, as will be seen in the succeeding steps, so that certain Months (e.g., Jan, Feb, Mar and Q1) appear in Columns; and, Accounts (e.g., Revenue, Cost of Sales, Gross Profit, Operating Expense and Operating Profit) appear in Rows.
2. In the VIP sheets pane, go to the Columns section and drag and drop Month to Rows. Double-click on the Month and change the display Members to show only the selected Members Jan, Feb, Mar and Q1. Click the Use Selected Members icon to commit changes.
Note: Following the example, there is no need to change the Members because the desired display Members for the Month dimension are already on display.
3. Next, go to the Rows section and drag and drop Account to Columns.
Double-click on Account and change the display Members to show only the selected Members: Revenue, Cost of Sales, Gross Profit, Operating Expense and Operating Profit. Click the Use Selected Members icon to commit changes.
4. Click Insert The Slice will appear in New Sheet (assuming that radio button is selected) as follows: