Here is my question. If my data has one column called Scenario (Current Year, Prior Year, Budget), and a couple measurement columns for volume and revenue, how do I make a calculated field to compare my Current Year measure against my Prior Year and Budget?

When I try to make a calculated field (Current Year v. Prior), how do I tell the field to pick volume for only the scenario of Current Year, and subtract volume from only the scenario of Prior Year?

Thanks!

Keith

Calculated Field.png