Min and Max date in pivot

[paolojolly]

Hi All,

I have a problem with the following document:

In a table for each item I have price and date of document fields

In a pivot chart I need to have for each item the last price in the filtered period ad the first and last document date of this price.

I need to calculate the information directly on pivot chart without change script

For example for item 005 last price is 0.94, last doc date for this price is 04/11/2014 and fist date for this price should be 15/10/2013.

I attach a sample document

Can someone help me?

Many thanks

[MK_QSL]

Add more more expression and remove 2nd dimension

FirstSortedValue(DISTINCT W_PRZ_LIS,-DATA_INI_RIGALIS)

[paolojolly]

Thanks. I tried to follow your suggestion but I did not get the result I need

[MK_QSL]

Upload the result you are looking for...

[paolojolly]

I need something like that

ITEM	PRICE in LAST DOC	MIN DATE OF DOC  WITH THIS PRICE	MAX DATE OF DOC  WITH THIS PRICE
005	0,94	15/10/2013	04/11/2014
025	1,38	15/10/2013	04/11/2014

Thanks

[giakoum]

that should give you the price :

firstsortedvalue (total <ITEM> W_PRZ_LIS, -DATA_RIF_DOC, 1)