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

    Accumulation in a Pivot Table



      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!