7 Replies Latest reply: Mar 12, 2015 6:24 AM by Onno van Knotsenburg RSS

    How to make values in a Pivot Table not to change when making selection

      Question:

       

      Im having a problem on my Pivot Table, how can i have Values not to Change when making selection on a Pivot Table

       

      e.g

       

      ProductSales ASales B
      Milk150100
      Butter2050

       

      Sales A and Sales C are calculated Sum, but how can i have them Not to change when selection is made.

       

       

      Any function to use?