5 Replies Latest reply: Feb 1, 2015 1:05 PM by Elena Prandoni RSS

    Accumulation in a Pivot Table

    Hans Müller

      Hi,

       

      i have following Problem. I build a Pivot table and i want a column which makes a sum about the values but with a Special function!

       

      There must be a start Point, it´s the first Month in the year (January), and there must be a end Point which the user can choose. My Expression is like this:

       

      =sum({<Monat = {"$(= '>=' & 'Jan' & '<='getselelctedvalue(monat))"}>} Werte)

       

      But it doesn´t work. Is there any solution?

       

      I need only a range between the fix start month and the flexible endpoint...

       

      I hope somebody can help me. Thanks!