How to show last date

[#1]

Hi,

I have folowwing requirement to get values in pivot table.

I need to show Last Date where Type='Receipt' and Payeetype='DD'.

Could anyone let me know how to write expression in pivot table under expression tab.

Thanks.

[Anonymous]

Will this work for u:

Max({<Type={'Receipt'},Payeetype={'DD'}>}LastDate)

[#3]

=max({<Type={'Reciept'},payeetype={'DD'}>}date)

or

you want to show last day value try this

=sum({<Date={$(Vmaxdate)},Type={'Reciept'},payeetype={'DD'}>}sale)

Vmaxdate=max(Date)

[suniljain · Accepted solution]

You can use following logic as expression to get max date with filters.

Max({<Type={"Receipt"},Payeetype={"DD"}>}LastDate)

Regards;

Sunil

[#5]

Thanks for your reply. it's working.