Prior Year's Information Displayed in Table Box

[#1]

I need help displaying the previous year's information in a Table Box.  The report is for Outside sales to Snapshot and take on the go.  It's a Pack - N - Go style report were it allows the outside sales person to select a District, Company, or Customer and gain a valuable knowledge before visiting said customer.

Setting up the Current Year's Table Box was easy, but I wanted to set up a prior year's Information box based on what year is selected, if no year is selected to have it show the Current Year Minus One.

[robert_mika]

Could you attached your file?

[#3]

The full QVW file?

[johnca]

Hi Matt,

Here's one example using a YEAR field that will change based on a selection in YEAR;

Sum({<YEAR={$(=Max(YEAR)-1)}>} Value)

Assuming Max(YEAR) = the current year select nothing and it returns last year's data. Select 2014 and it returns 2013 data, etc.

HTH,

John