Total in Pivot Table not coming correctly

yashcena — Mon, 31 Jul 2017 14:20:47 GMT

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

Re: Total in Pivot Table not coming correctly

sunny_talwar — Mon, 31 Jul 2017 14:25:47 GMT

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))

topic Total in Pivot Table not coming correctly in QlikView

Total in Pivot Table not coming correctly

Re: Total in Pivot Table not coming correctly