Selecting two different versions of data (using filter/button) in the same table

[Krishnan92]

Hello All,

I have a scenario where I have a straight table and I have my Actual fields and forecast fields in the same row and calculated measures followed by. Now the requirement is this whole table needs to be dynamic. Like instead of Actual and Forecast, I can compare Actual and Actual, Forecast and Forecast for different years.

Below is the screenshot for your reference.

[daturpin]

What do you want it to do?

Actual-to-actual, forecast-to-forecast, of what?  The solution will probably end up being a seeded IF statement, where the IF statement is of the syntax if(expression, then, else), but you can do pretty complex things by seeding, like if(expression, if(expression, then, else), else)