Step by Step - Getting Started Guide

Step 4 – Using the Pivot Table

How to Sort and Unsort Data

• To sort data in descending order:

  1. Point the mouse to the dimension or member name and click .  The options menu appears.

  

  2. Click the Sort by … option.  The grid and chart are sorted by the selected data in descending order.
  A appears next to the dimension or member name in the grid, enabling sorting in ascending order.

• To sort data in ascending order:

Click the next to the dimension or member name in the grid.  The grid and chart data are sorted by the selected data in ascending order.  The changes to , enabling sorting in descending order.

• To unsort data:

1. Point the mouse to the dimension or member name and click .  The options menu appears.

2.Click Remove Sort.  The selected data sort is removed.

 

<-Previous Step Next Step->

 

 

SaaS BI Overview

Spreadsheet Analysis

Pivot Table Tutorial

Corporate Data Analysis

Analytics for Salesforce

 

Pivot Table Updates

Register here to get updates and the latest news about Pivot Tables for Google Docs.