Previous period in one column with current (pivot table)

[Anonymous]

I am wondering, it is possible to get previous period sum in one column with current period?

for ex. now, i have table like this:

I use  this formula for calculating last period

=SUM({$< Field1 = {'Income'} ,  Period = {"$(=

                                                   '>=' & NUM(ADDYEARS(MIN(Period),-1))  & '<=' & NUM(ADDYEARS(MAX(Период),-1)) 

                                                                  )"}>}  Value)

[sunny_talwar · Accepted solution]

Try this

Before(Sum({$<Field1 = {'Income'}, Period = {"$(='>=' & Num(AddYears(Min(Period), -1)) & '<=' & Num(AddYears(Max(Период), -1)))"}>} Value))

Read about Before/After here

Missing Manual - Before() and After()

[stabben23]

use another Dimension than year maybe?

[Anonymous]

Sunny, thx =). It's helped