Totals in Pivot table

[nehasaxena]

Dear Experts,

I am facing problems with displaying total in Pivot table. I have already gone through various posts in community but not found the solution for my issue. Here is my expression -

=If(Month='JAN',Sum({$<TypeofData={'Actual'},Year={'Pr-Live'}>}$(vExpr_UnitValue))/1000,if(Unit='Mio Litres',Sum({$<Year={'Pr-Live'}>}RF022016Ltr)/1000,Sum({$<Year={'Pr-Live'}>}RF022016)/1000))

Table shows the total of Feb to Dec data and not including the value of Jan.

I understood that I need to use aggr function but how it fits in my expression can somebody guide me?

Thanks.

Best regards,

Neha

[nehasaxena]

Unfortunately this is not working