Figure 12.13

After clicking Advanced, you get to the powerful PivotTable Field Advanced Options dialog. Here, you can specify that customers should be sorted based on Descending revenue.

PivotTable Field Advanced Options

Page field options

* Retrieve external data for all page field items {raster performance} Query external data source as you select each page field Item {requires less memory) f"~| Disable pivoting of this field (recommended) AutoSort options O Manual (you can drag items to rearrange them) O Ascendrig © Descending

Data source order Using field;

Top 10 Auto5how ©Off Ooq Show;

Using field;

Sum of Revenue

0 0

Post a comment