Aggregate functions on Grand Total - OBIEE (using New Calculated Item)

After long time :) busy with Personal works.

Today ,i will explain how to calculate "Average" in Grand total In the below screen shot i have Customer Type and Booked Amount .I want to calculate Average at the end ,of course we can do it using Combine with similar request ,but we can easily do it with single request using New Calculated Item option in Pivot table

Step1:

Step2:

Step3:

Step4: We can change function to "Avg/Count/Last/First ......" .In above example i had taken Function "Average" format the Title with different colour

Finally,

!!!!Wish you a very Happy New year and more success in your Life!!!!