Filtering on a column with powerprompts

[lsmani]

Hi gurus,

I need to know can i apply a filter for a particular column in powerprompts. The scenario is this i have two columns A and B associated with years. i need to bring the values in the columns correspondingly what i choose in years.

Example would be

col A year = 1999 , col b = year= 2002.

now i should display on col A for year= 1999 and on
Col b = 2002.

Any work around please...if any.

Also i would like to know whether the report called in PDF
can be viewed as HTML / Excel sheet etc..

TIA
Lsmani