6 Replies Latest reply: Jun 13, 2014 12:12 PM by ANGIE DM RSS

    How to add calculated percentage based on the above rows

      The following is the pivot table that I've generated which contains only two rows of sales.

       

       

      I tried to add a third row to display the ratio of the sale, say $54,508.35/$38,874.04-1 which will give me 40.22%. If possible, it will ideally showing as following. (I've made the following pictures from EXCEL.)

       

       

      But other than showing the Total of the sale, couldn't figure how

      1. how to add this extra row

      2. how to put the calculated values.

       

      Please help.