Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Unfortunately this is not working