9 Replies Latest reply: Feb 20, 2015 3:43 AM by Rudolf Linder RSS

    Today, one year ago in a Pivot Chart

      Hi Experts

       

      I am trying to disply values in a Pivot Chart.

       

      I have the following formula:

       

      Sum ({<Auftragsdatum_aktJ={$(VDanteminus1Year)}>} ([Rohertrag_aktJ]))

       

      It gives me the Sum of all earnings today, one year ago. BUT what I would like to retrieve is the sum of all earnings today, one year ago and earlier. Thus, < today, one year ago.

       

      How would I have to script this?

       

      Thank you for your help!

       

      Jan