How to get the sales in the same period last year by Sat Analysis?

[Anonymous]

I have a pivot table,column1 is sales amount in this year,column2 is sales amount in last year.

For example, when I select the period(201010;201011,201012),then the column1 will be the total sales amount in the period(201010;201011;201012).

And I want to put the total sales amount in the period(200910;200911;200912) into column2,how can I do?

column1 formula: sum(SalesUnit*IMPrice)

column2 formula: ?

[Anonymous]

This should do the trick:

Sum({$<Year={$(=Max(Year)-1)},

DATEFIELD={'<=$(=AddYears(Today(),-1))'}

>}

(SALES*IMPrice)

[llauses243]

Hi,

This can be useful, pls see attached

Good luck, Luis

[Anonymous]

Hi llauses, thank you very much.