Oh interesting. I've never heard of this in saved searched. I'll have to do some googling to figure out how to do that. It might at least get them closer. @ryanhowson That's currently how I have it - at the top of their dashboard. But because we need to compare it against data that currently lives in Salesforce and isn't integrated to NetSuite yet, they need to be able to download it to Excel.

Decode(comparison rule, desired comparison, result field) would work for this. Or case statement. Your comparison rule would be converting your period into a result, your desired comparison would be the period you want the values from and them your result field would be whichever field you would normally put as a column