Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add more more expression and remove 2nd dimension
FirstSortedValue(DISTINCT W_PRZ_LIS,-DATA_INI_RIGALIS)
Thanks. I tried to follow your suggestion but I did not get the result I need
Upload the result you are looking for...
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
that should give you the price :
firstsortedvalue (total <ITEM> W_PRZ_LIS, -DATA_RIF_DOC, 1)