Thanks for your reply.
I did according to what you said but it gave me the total of individual component instead of the annualised value.
However, out of no where, I was able to get the answer using only the cross table and adding a new measure, "=Avg(Cost)*12" to a new field.
However, Thanks you very much for your respond and appreciate a lot if you could explain me the logic behind using of "ColumnNo()=0" statement.
ColumnNo() returns the number of the current column within the current row segment in a pivot table. The first column is number 1.
If the pivot table has multiple horizontal dimensions, the current row segment will include only columns with the same values as the current column in all dimension rows except for the row showing the last horizontal dimension of the inter-field sort order.The inter-field sort order for horizontal dimensions in pivot tables is defined simply by the order of the dimensions from top to bottom.
In pivot table, instead of ColumnNo(), you can aslo use Dimensionality() like below.
if(Dimensionality()=0 or SecondaryDimensionality()=0,Avg(Cost)*12, Sum(Cost))