Max date in dimension in a piro table

[#1]

hallo everybody,

I need your help for a set dimension in a dimension. I need the last date for a special criteria as dimension.

I use the max function but this doesnot work.

Can anybody help me.

One sample for my formula:

if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE', max(INVT_TRANS_DETAIL.TRAN_DATE))

Thanks and greetings Sven

[Nicole-Smith]

if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE' and INVT_TRANS_DETAIL.TRAN_DATE=$(=max(INVT_TRANS_DETAIL.TRAN_DATE)), INVT_TRANS_DETAIL.TRAN_DATE)

[tresB]

May be like:

Aggr(if(INVT_TRANS_DETAIL.TRAN_CODE='SPRECEIVE', max(INVT_TRANS_DETAIL.TRAN_DATE)) , INVT_TRANS_DETAIL.TRAN_CODE)

Or,

Aggr (Max({<NVT_TRANS_DETAIL.TRAN_CODE={'SPRECEIVE'}>}INVT_TRANS_DETAIL.TRAN_DATE),INVT_TRANS_DETAIL.TRAN_CODE)

Note: Aggr() might not be required if you want the result in a text box

[#4]

thanks for your answer, but this formula does not work for my pirotable

[Nicole-Smith]

Can you post an example .qvw?  It's almost impossible to help without one.