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