Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can use following logic as expression to get max date with filters.
Max({<Type={"Receipt"},Payeetype={"DD"}>}LastDate)
Regards;
Sunil
Will this work for u:
Max({<Type={'Receipt'},Payeetype={'DD'}>}LastDate)
=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)
You can use following logic as expression to get max date with filters.
Max({<Type={"Receipt"},Payeetype={"DD"}>}LastDate)
Regards;
Sunil
Thanks for your reply. it's working.