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

    Problem with rolling

      Hi all,

       

      I have this situation:

       

      SEE(QVW).

       

      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.