6 Replies Latest reply on Jun 14, 2017 1:05 AM by Loretta Xia

    Fixed Aggregation Level to month when choosing viewing by quarter/year

    Loretta Xia

      Hi friends,

       

      I tried to find out the FX adjusted amount for my sales information.

      I have all monthly sales amount(S) and FX rate(r).

      The desired calculation of FXadj sales amount for the first quarter should be: (S1*r1+S2*r2+S3*r3)

      I'm not clear how to achieve that ;p  Anyone can help?

       

      The worksheet is attatched here.