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.