3 Replies Latest reply: Aug 12, 2017 2:00 AM by Enrique Colomer RSS

    question (Total)

    NEVILLE DHAMSIRI

      I have done a calculation on fixed value after loading tow tables of which this cell was considered as an absolute cell reference.But once I brought this in to a pivot table, total doesn't appear as 100%. I may present my case as below:

       

      Class_Code               Amount          Percentage (Taken through a formula)

      MC                             500               10%

      FR                              2000              40%

      TC                              1000               20%

      M3                              1500               30%

      Total                            5000                100%  (Once data are loaded in pivot table, total % as 100 is not appeared).

      Please explain how this will be obtained



      Thanks


      Neville