Skip to main content

 

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
  1. Jul 31, 2015, 4:25 PM

    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.

     

    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?

0/9000