need help in requirement

[siva8]

Hi All,

i have a table like below

product,date, price

apple iphone ,1/1/2019,30000

one plus,5/1/2019,35000

apple iphone ,15/1/2019,40000

my requirement here is as explained as below in scenarios

scenario 1: 

in calendar object if i select 2/1/2019 the straight table should show [product apple] and [price of apple] [(i.e. 30000) --- latest price at 2/1/2019]

scenario 2:

and if i select 10/1/2019  the table should show [product apple and onplus ]and price of the both [i.e. 30000 and 35000].------- latest price at  10/1/2019

scenario 3:

and if i select 20/1/2019  the table should show [one plus and apple ] and price of both [i.e. 35000 and 40000] --- because the latest price at the time of 20/1/2019 for apple and one plus was 35000 and 40000 respectively .

finally if i select any particular date in a calendar object the table should show latest prices of  product .

thanks in advance

thanks

siva 

[siddheshmane]

Hi Siva,

Assuming you have a master calendar table setup to select any dates for which you want to see the data. 

I stored the date selection in a variable and then used the below set expression to display my values.

MAX({<DATE = {'<=$(=vdateselect)'}>}PRICE)

Hope this helps.

Regards,

Siddhesh H Mane.