Most RecentMost ViewedMost LikesPivot 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 manually Solved