Display data from pivot table

Hello

I am trying to extract data and diplay it by querrying a pivot table.

I would like to display the date and the corresponding maximum market price of an investment and the date and market price when it was last traded in a separate tab.

Attached "Display data from pivot table.xls" contains the data, the pivot table & the report. I tried using a VLOOKUP together with =max() on pivot table but i cannot achieve the result.

Thanks for you assistance
RegardsDisplay data from pivot table.xls

We can reference the main table instead, since each row has all necessary data...

So in D7 of Report!: =MAX(IF(Data!$C$4:$C$38=Report!B7,IF(Data!$B$4:$B$38=C7,Data!$E$4:$E$38)))

confirmed with CTRL+SHIFT+ENTER and copied down

in E7:

=SUMPRODUCT(--(Data!$B$4:$B$38=C7),--(Data!$C$4:$C$38=B7),--(Data!$E$4:$E$38=D7),Data!$D$4:$D$38)

copied down

in F7:

=SUMPRODUCT(--(Data!$B$4:$B$38=C7),--(Data!$C$4:$C$38=B7),--(Data!$D$4:$D$38=G7),Data!$E$4:$E$38)

copied down

and in G7:

=MAX(IF(Data!$C$4:$C$38=Report!B7,IF(Data!$B$4:$B$38=C7,Data!$D$4:$D$38)))

confirmed with CTRL+SHIFT+ENTER and copied down