- last edited on
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 manually
06-15-2019 04:02 AM
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-8... to work with measures. If not - not sure what to do.