5 Replies Latest reply: Nov 10, 2014 11:03 AM by ioannis giakoumakis RSS

    Min and Max date in pivot

    Paolo Guidolin

      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