pivot table linked report using function

HTML Code: 

Not entirely sure I understand but in general terms - based on the specific sample:

B22:
=MIN(IF(ISNUMBER(INDEX($B$4:$D$17,0,ROWS(B$22:B22))),$A$4:$A$17))
confirmed with CTRL + SHIFT + ENTER (enter alone will not suffice)

C22:
=LOOKUP(9.99E+307,INDEX($B$4:$D$17,0,ROWS(C$22:C22)),$A$4:$A$17)
confirmed with Enter

D22:
=SUM(INDEX($B$4:$BD$17,0,ROWS(D$22:D22)))
confirmed with Enter

B22:D22 copied down as nec.

Originally Posted by murarihyd

can you fill it up the attachement and post it.

Re: B22 - I suspect you did not confirm as an Array (confirming the formula with Enter alone will not suffice as stated previously)
You need to be able to do this on your own so in this instance I think you will get some value recreating it yourself.

Re: C22
9.99E+307 is a big number: 9.99*10^307
This number used with LOOKUP in this context will return the last numeric value found in the precedent range (lookup_vector)
Where a result_vector is specified (as is the case here) the value associated with the last numeric value found in the lookup_vector is returned - here for ex. we return the associated date.

For more info. on last values etc see: http://www.xldynamic.com/source/xld.LastValue.html