Rangesum in pivot Table

[P_Kumar]

Hi,

I have attached qvf.  Requirement is to consider sales of last month as a value for this month.  Everything working fine in a Year but when we switch the years, last year's December isn't being carry forwarded as current year Jan value.  Pls advice.  Thanks.

[ryo_okabe · Accepted solution]

Hi,

Why don't you chenge to following expression?

1.before( total sum(Sales),1)
or
2.Sum(Aggr(Above(total Sum(Sales)),(Year,(NUMERIC,ASCENDING)),(Month,(NUMERIC,ASCENDING))))