1

Topic: To select value of a column from the pivot table

There is a pivot table of approximate type

Article Region Total Department
The tax Siberia Novosibirsk Summa1 Summa2
Omsk Summa1 Summa2
Center Moscow Summa1 Summa2

How from it to select value of the first column in a certain line if to look across the field department?
For example for Omsk it is necessary to collect all the line long with Omsk in a separate file, all I copy except the first-second column.

St = ActiveSheet. PivotTables ("Summary 1").PivotFields ("Article").Cells (j, 1).Value

Does not swear, but also produces an empty line.

2

Re: To select value of a column from the pivot table

nata44845;
Try as on a screenshot, it can is necessary for you.
The city should be in the filter

3

Re: To select value of a column from the pivot table

At PivotFields there is no property Cells like...

4

Re: To select value of a column from the pivot table

Akina;
Yes understood already, it is necessary to go simply through Cells and to rise on a column to the first nonblank.

5

Re: To select value of a column from the pivot table

nata44845 wrote:

it is necessary to go simply through Cells

Well generally at PivotTable is DataBodyRange Property.