Problem with Pivot table

[tizianacaem]

Hello all.
I have a problem with an expressions in pivot table.
In lines of pivot table I have calculated the Sales of CurrentYear and PreviousYear.
If I show the dimension Year in column, is possible to see the data, like the following example?

2009 2010 2011

sales Current Year sales2009 sales2010 sales2011

sales PreviousYear sales2008 sales2009 sales2010

thanks

Tiziana

[johnw · Accepted solution]

I'd handle it with an "AsOf" table linking an AsOfYear to both the current year and the previous year. See attached.

[tizianacaem]

Thank you very much.. it work rightly!!