9 Replies Latest reply: May 29, 2014 9:32 AM by Amir Vastani RSS

    Problem with rolling

      Hi all,


      I have this situation:




      I want to create a chart, pivot table( product, year month ---- like dimensions and sum(Sales) expresison and the rollongo of sum(Sales)...


      I do: sum({$<     DATE={"$( ='>='&(date(monthend(max(DATE),-12)))&'<='&MONTHEND(MAX(DATE)) "} >} SALES)



      Someone any idea?


      The expected result is in yellow in the excel file.