I have a budget & forecast vs actuals table as shown below. Actual, Current Budget, and Current Forecast are Version Type dimensions that are associated with the Version dimension as properties. The 5 columns within the red box are calculated items. I applied conditional formatting to the variance calculated items.
However, when the month changes, the formatting goes away as shown below:
The intent for the above views is to associate the month dimension with an application variable of “Last Closed Actuals Month” - dynamically updating to show stakeholders their monthly and YTD variances.
Is there any way to apply the conditional formatting across the entire calculated item? Or a different approach to BvA views entirely? The approach shown above contains 6 conditional formatting rules (3 columns x2 rules each), so doing this for every month doesn’t seem viable. Thanks!
