select second last date

[#1]

hello.

i have a table with 2 fields: donation place, donation_last_date.

the last date field works ok.

the problem is when a donation was cancelled it still shows me the last donation date and i would like to show only the last donation date for a donation that was not cancelled. it could be the second max date or the third.

place	donation_last_date
A	25/05/2015
B	01/06/2016
C	12/10/2015
D	09/08/2014

now if donation A and B were cancelled i would like to show the previews donation date that was not cancelled

thanks

for donation A i have those dates:

25/05/2015 -cancelled

22/04/2015 -cancelled

10/04/2015 -donation done

[CELAMBARASAN]

How will you decide the donation is cancelled? based on which field, since you have only 2 fields.

try if you have status field

Max({<status-={'Cancelled'}>} Donation_last_date)

[Kushal_Chawda]

If you just want to select second last date then

=max(Donation_last_date,2)

[Chanty4u]

=Firststoredvalue(Donation_last_date,-2)

[#5]

STRIAGHT TABLE

with place as dimension

Max({<status={'donation done''}>} Donation_last_date)

[avinashelite]

try like this

=max({your set analysis condition }Donation_last_date,2)

[#7]

i do have a field

it does not work. it still shows me only the last donation

[#8]

it does not work. it still shows me only the last donation

[#9]

it does not work. it still shows me only the last donation

[#10]

if you do not have a field , then how we will verify that donation has been done or not.

We need to have some indicator to check the donation status.