Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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
if you select 2 values of year you get the last value for max year.
Is it ok for you?
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....
ok, I'm understand now.
may be you can create a new table with group by statement in the script:
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 ....