Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I'd handle it with an "AsOf" table linking an AsOfYear to both the current year and the previous year. See attached.
I'd handle it with an "AsOf" table linking an AsOfYear to both the current year and the previous year. See attached.
Thank you very much.. it work rightly!!