Receive a formula in a pivot table
Karabadji
Posted messages
4
Status
Membre
-
Raymond PENTIER Posted messages 58549 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58549 Registration date Status Contributeur 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
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 réponses
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)
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)
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
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