3 Replies Latest reply on Feb 7, 2014 6:15 AM by Matt Lutton

    How do you create Total of moving total?

    Gorazd Ozimek

      I would like to have a calculated field, which would sum 12 months (moving total) but at the same time sum all of elements. So let's say if I have sales data by company, I would like to have 12 months moving total, but also the sum of moving totals of all companies. Is this possible? I am getting errors in formulas, because TOTAL() cannot use another aggregated field.

       

      It is essential that the calculation is done via calculated fields (not with quick calculations).


      Thank you!


      Regards,

      Gorazd