Can your two data sources use join or these two are from extract or tableau server?
and what should be when Aug 2018 comes in and should be another delta column for Aug?
Thanks for ur support on this.
At the moment the data source are from extract only. Later they will be on a tableau server. Would it be possible without a join and just use data blending?
When the actual date is 01.09.2018 then i would want FC vs ACT for Aug 2018 and FC for Sep 2018 and Oct 2018. The Delta should only apply for Aug 2018. The data for Jul 2018 will not be relevant anymore. I only require the previous months data for the ACT vs FC comparison. Its going to be a rolling liquidity forecast.
Thanks a lot for your help
In this case, other than using the dashboard, I don't have any other solution.