Forum Discussion
Solved
Pivot tables - calculated fields
I want to add calculated field in consolidated pivot table, not in standard pivot table i.e(rate=value/qty) in column as i have shown in attached excel sheets rate1 & rate2 which i have calculated ma...
Right click on Table1 in PivotTable Fields and Add measure
Name it Rate1 and start typing formula
Select proper fields, finally
Same for Table2 and Rate2. Add created measures to PivotTable.
Please check attached.
On which version of Excel you are?
excel 2013
I see, it was removed for 2013. If you are on Pro Plus you may activate Power Pivot https://support.office.com/en-us/article/start-the-power-pivot-add-in-for-excel-a891a66d-36e3-43fc-81e8-fc4798f39ea8 to work with measures. If not - not sure what to do.
- ok sir, thanks for your time and early reply
- -@sergei baklan