8 Replies Latest reply: Jul 19, 2016 8:02 AM by Kamiel Rajaram RSS

    How to switch different expression in a pivot table?

    Jim Chan

      Hi guys,

       

      I have a pivot table need to create. and have to be very flexible, and i dont know how to do it.

       

      1) The product table by default, it will show Month 1st (Jan - Dec). When i select a Month, it will switch to Day, showing(1-31)

      2) The product table by default it will show Quantity expression 1st. Then, When i click on Amount button, it will show Amount instead of Quantity.

       

      I only know it has to play around with "Enable Condition".

      how_to_do.png

       

      Rgds,

       

      Jim