Total in Pivot Table not coming correctly

[yashcena]

I have a horizontal pivot table in which there are four expressions. I have to show the average of the 1st expression and the total of the other 3.

I want to show the entire total i.e available months' data+projected months' data

Thanks,

YASH

[sunny_talwar]

Try using this as your expression

=Sum(Aggr(IF(IsNull(GetFieldSelections(Year)) ,if(sum({<Year={$(=vCurrentYear)},[Cost Element Bucket] ={'Salaries & Wages'}>}eUSD_Amt),sum({<Year={$(=vCurrentYear)},[Cost Element Bucket] ={'Salaries & Wages'}>}eUSD_Amt),num(sum(TOTAL{<Year={'$(vCurrentYear)'},[Cost Element Bucket] ={'Salaries & Wages'}>}eUSD_Amt)/COUNT({<Year={'$(vCurrentYear)'}>}DISTINCT TOTAL(Sp_Month)),'$##.00 M')),num(sum({<Year={$(=vYearSelection)},[Cost Element Bucket] ={'Salaries & Wages'}>}eUSD_Amt)/1000000,'$##.00 M')), Month))