I have a small dataset that brings in some financials, a year field and a text field called Season. I'm looking to have 2 sets of data, one for the max financial year selected and one for last. The figures aren't an issue, they're working fine but it's the titles I'm struggling with. For the max year =If(Max(Year)=Year,Season) works, but what do I need to do for the previous year?
Can you share a qvw sample so that we can see where you're using this expression.
Might be helpful see this post: