last value

[#1]

Hi,

I have the following data and was wondering what is the best approach to collect the last value...

value, date

1532.00, 29/01/2010

1560.00,31/01/2010

1590.00,17/9/2010

1420.00,30/12/2010

1500.00, 29/01/2011

1300.00,31/01/2011

1990.00,17/9/2011

110.00,30/12/2011

what I am looking for, is while doing the chart, and in case the year selected ... then I should show the values related to last value of each year, and if months selected then the same thing to show the last value of each month ....

any help

[sparur]

Hello,

I think, that the most simple way it's:

- create a variable, for example, with name vMaxDate and with definition: =Date(max(TransDate), 'DD/MM/YYYY').

- create a Set Analysis expression with this variable.

for more details, please see in my small example in attachment.

[#3]

many thanks Sparur,

I have set earlier the same , but my issue is that if I select the 2 years (2010 & 2011) I should be able to see the last value of each year in the chart .... in your example, I can only see one selection at a time

[sparur]

if you select 2 values of year you get the last value for max year.

Is it ok for you?

[#5]

nop, if I select the 2 values, I need to see the value of each year (i.e. 2 records in the sheet) ... currently I see the last value of 2011....

[sparur]

ok, I'm understand now.

may be you can create a new table with group by statement in the script:

[#7]

Thanks, that works for me ... but I noticed the layout used in the list box is not available for me.... is it a theme that I should download ....