View original (French)

Receive a formula in a pivot table

Karabadji Posted messages 4 Status Member -  
Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   -
Hello,

I have a problem with pivot tables
I want to add additions to subtractions or formulas by row, and I always get the same result when I drag to copy the same formula

Thank you.

Configuration: Windows / Chrome 43.0.2357.130

2 answers

  1.
    Raymond PENTIER Posted messages 58226 Registration date   Status Contributor Last intervention   17 488
     
    Hi.

    You are in the pivot table: at the top right, it displays "PivotTable Tools" ; then you go to
    Options / Calculations / Fields, Items & Sets / Calculated Field

    --
    Retirement is great! Especially in the Caribbean... :-)
    Raymond (INSA, AFPA, CF/R)
    3
  2. gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    I fear you may not have understood how PivotTables work.
    Formulas work on the entire column if you code them in tools / formula / calculated field
    --
    Always zen
    Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
    0
    1. Karabadji Posted messages 4 Status Member
       
      Thank you for your response
      indeed, I don't have much knowledge about Pivot Tables,
      I'm using Excel 2013 and I can't find tools / formula / calculated field
      what will this function allow me?
      0