Hi everyone,
I have attached a packaged workbook based on Superstore data set.
I would like to display the prior two years (ie. 2011, 2012) in columns before the current year(order date). The catch is I want this based on the year the user selects in the filter.
Many thanks,
Allyson
17 answers
Hi Allyson,
I don't know how to save it as version 8, I google'd it and I don't think there's an easy way to do it.
Did you drag your calculated field into Label? Why isn't it working for you? Here is what my calculated field looks like.