Info

The solution in the current case is to grab the data field and drag it over to become a column field. Keep a close eye on the mouse cursor as you drag. The blue shaded area indicates whether you are about to drop in the column field or row field area. Figure 12.24 shows the various mouse cursors when pivot table fields are being dragged.

Figure 12.24

As you drag a pivot field in the user interface, the blue portion of the mouse cursor indicates where you are dropping the field.

Row Field

Data Field

Remove Field

Row Field

Data Field

Remove Field

Figure 12.24

As you drag a pivot field in the user interface, the blue portion of the mouse cursor indicates where you are dropping the field.

Page Field ooopg Column Field

Page Field

With the data fields set up as a column field in the pivot table, the various data fields run from left to right, as shown in Figure 12.25.

Figure 12.25

With the data fields set up as a column field, you get a typical accounting-type report.

Figure 12.25

With the data fields set up as a column field, you get a typical accounting-type report.

0 0

Post a comment