Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table with three columns corresponding to the years 2012, 2011 and the difference bettween them. Now I also want to load 2010 data but I want to keep only three columns. I'm looking for a smart way to show always the last year loaded (2012 so far) with 2011 or with 2010, so the three columns would be 2010-2012-difference or 2011-2012-diference.
How can I do so.
Thanks
Here's a thread that explains how to use Set Analysis to pick the years you want to display dynamically:
The thread show me how to fix a year but I need to fix two of three year in the view I tried with an 'or' but maybe I did not find the right syntax...