Notifications
Clear all
Topic starter
Hi !
there is possibility to edit data in pivot table
e.g. i have data like (150000) and i want to divide in (150000/100000) = 1.5
regards/Saliha
Posted : 22/09/2018 12:42 am
Hi Saliha
You cannot edit data in a PT.
You can either add a helper column in your source data and divide it there or you can create a calculated field in your PT.
https://www.myonlinetraininghub.com/excel-pivottable-calculated-fields
It is better if you attach a sample file and an expected result.
Sunny
Posted : 22/09/2018 10:29 am
