Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
my data looks like this
date price
1/02/2010 100
5/10/2010 500
6/01/2011 50
7/09/2011 300
8/02/2012 400
7/05/2012 600
Now i want output as
Maxdate Latestprice
7/05/2012 600
because among all dates 7/05/2012 is the maximum date and 600 is the corresponding price.
But if select any year (eg:2010)
output must be
Maxdate Latestprice
5/10/2010 500
. the latest price must show me the coresponding value of date(maxdate).
Hi Avi,
You have to use Set Analysis to get the Price for the Max(Date) in your selection. For example, like this:
Max({<Date={'$(=Max(Date))'}>} Price)
I have attached a document with an example.
Juan Gerardo
Hi Avi,
You have to use Set Analysis to get the Price for the Max(Date) in your selection. For example, like this:
Max({<Date={'$(=Max(Date))'}>} Price)
I have attached a document with an example.
Juan Gerardo
Hi Avinash,
Please Find the Attached File. Hope this helpful for you
Regards,
Nirmal.
Hi Avi,
Above Mentioned both answers are working fine
regards,
Ananth
HI
FOR THIS OUTPUT--
maxDate | pricenew |
7/5/2012 | 600 |
WRITE CODE-
LOAD
date(max(date))as maxDate,
FirstSortedValue(price,-date)as pricenew;
LOAD date,
price
FROM
(ooxml, embedded labels, table is Sheet1);
**************************************************************
FOR THIS OUTPUT, WRITECODE--