4 Replies Latest reply on Mar 30, 2017 7:19 AM by Alexandrina Biraltchanova

    How to create a calculated field of a calculated field? Or maybe a formula that could work.

    Alexandrina Biraltchanova

      What I am trying to do is the following. I have all my data in volume (units), however I use it to calculate participation of each company and brand (%). So what I want to calculate is the variation in the participation of certain brand among 2 months.

       

      For example, if I have this:

      Sales
      CompanyJanFebMar
      Cats100120110
      Dogs707560
      Fishes807075
      Total250265245

       

      I calculate participation (I do this with quick table calculation).

       

      SoM
      CompanyJanFebMar
      Cats40%45%45%
      Dogs28%28%24%
      Fishes32%26%31%

       

      And what I need to calculate now is variation in SoM:

       

      SoM Variance
      CompanyJanFebMar
      Cats-5%0%
      Dogs-0%-4%
      Fishes--6%4%

       

      Any suggestions?