OBIEE: New Calculated Item in Pivot Table

This post explains how to calculate "New Calculated Item" option in Pivot table:

Step 1:

Step 2:

Step 3:

Step 4: We can change function to "Avg/Count/Last/First ..." In above example I have taken Function "Average" format the Title with different color.