Data Range Property

This property returns a Range object representing the data area associated with the given PivotItem. To illustrate, the code:

ActiveSheet.PivotTables("Sales&Trans"). PivotFields("Store Type"). PivotItems("Company").DataRange.Select results in Figure 20-37.

Figure 20-37. DataRange for Store Type = Company

A

B

C

D

E

F

G

1

Year

(All) "V

2

3

Period

4

Store City

Stor e Type

Data

1

2

3

4

e

BOSTON

Company

Trans

23248

28714

28672

28602

5

Sate

44678

46927

46256

46223

7

Franchise

Trans

13993

15942

13275

13210

8

Sate

21816

2"! 73$

18632

18325

9

LOS ANGFI..EÎ

Company

Trans

34583

35338

35?; S 2

35 00 il

10

Sate

123478

129564

12S340

125410

11

Franchise

Trans

71583

72947

75619

7431=2

12

Sale

262431

268274

279325

274531

13

¡VEW YORK

Company

Trans

24616

26104

27015

2®854

14

Sate

73Q-39

85251

87905

68J>5e|

15

Franchise

Trans

53273

54.?,51

51822

51218

16

Sate

176353

102451

1705T;7

167446

A 1

0 0

Post a comment