Return Value Based on Column Row Pivot Table

[raychow22]

Hi Forum

I am trying to use a formula on my pivot table to return column value based on where the number is for the rows. See spreadsheet.

I.E.

For Row 0000100, the value is on AD12 which will return the column value of AD11

For Row 0010000, the value is on AD13 which will return the column value of AD11.

[GlennUK]

Look at the new PivotTable at Z43.

It has put the column item in the row area, so that the values you want AD11, in your posting, appear alongside your original row designators.

[raychow22]

Ahh Nice. Thanks!