how do i sort data in pivot table.. i have calculated sum(total_defects) and i need to sort pivot table as per expression calculated..
go to the Sort tab.
tick the Checkbox Expression and paste ur expression here.
Choose asc or desc.
Right Click on Pivot table ==> Properites ==> Goto Sort tab ==> Check on check box "Expression" ==> Paste your expression sum(total_defects) in the box.
Let me know if this one help you.
Retrieving data ...