Small function i

[mhovidz]

Hi guys,

I have a task that I need to get the 95th item of a certain product. I need to get it in a database type table. Getting it using a formula array like this is easy task.

=SMALL(IF(Product_Range = "Prod1",Value_range),ROUND(COUNTIF(Product_Range,"Prod1")*95,0))​

But my question is, can I apply it in pivot? So that once the user filter certain information, it will automatically provide the required 95th item?

Thank you in advance