Pivot tables

Pivot tables are among Excel's most powerful tools. A pivot table is capable of summarizing data in a handy table, and this table can be arranged in many ways. In addition, a pivot table can be manipulated entirely by VBA. Data for a pivot table comes from a worksheet database or an external database and is stored in a special cache, which enables Excel to recalculate rapidly after a pivot table is altered. Figure 2-26 shows a pivot table.

J;

CKjwrii lb;,

1 jU c vh:.:

— Ï'

A

B

:

G

E

F G

uljjb

.

j

TfJF

3d«

j

5

Q mto Quni^it

Stiytwjn*

fnttiH]

1HÜM

«

Re*lwl

Connecticut

Î.00

PlOO

30 61

f

Mrint

tw

i.os

100

S

Mtsudtiiitlti

95. Ï5

0.00

0.00

11 JJ

.

Ntw HimfuMrc

CM

0,00

Ï.00

0.«

10

Klvxfe HUry)

000

0,00

D00

000

It

Vïfnwnl

Û.W

0.00

OuOO

Ü.00

Rr^inn 1 lcl.il

«.IS

0.1»

fluM

CJK

u

SfwJirrtv

%m

7,30

17.00

turn

H

MUM

tUO

ii.U

Hu»

Ou»

u

n-cian 1! loi il

Ü.M

Duoa

DLK*

Jt

Region JO

MIWM

i:.i3

13.1»

fr«

D.K

1/

Mjrvljnd

M.I/

U.ÏS

t.OJ

to»

It

Pcr.niilvoiii

WIS

1X00

Virgin a

71. T)

IIA

¡&«

»

WMtVlriPNi

Ml

1,70

7.71

¡1

RP(lon|*To(al

?iq

1W.H

¡¡ft«

90. n

22

Region IV

j\ Id [idf.j

HMI

IS,71

iii.™

0.00

11

FkHMa

J3 77

37:

21 M

J1-1

11

Geoffla_

3D.i3

i).W

J35.05

35.51

ÎS

Kcmucky

77.6S

1Ü.01

CM

J3».S3

Î6

MlUUHppi

14.04

ltj.it.

jii.lH

MB

¿1

North CJrthrti

UUi

11Ï.»

22S.01

ja

fouihCvchn*

Ï4U

__uw__

* H

-■

*

Figure 2-26: Excel's pivot table feature has many applications.

Figure 2-26: Excel's pivot table feature has many applications.

CROSS- See Chapter 17 for information about manipulating pivot tables with VBA.

REFERENCE

0 0

Post a comment