I want to color the column if my Actual is equal and greater than the Forecast in pivot table.
As shown in the below screenshot, on click of Jan-2020 its working for some category and for some category its not working. For e.g. Adj EBITA Actuals and Forecast is same, then too its not showing in green.
Color logic: =if(aggr(sum(forecast_bmc), category,period)=aggr(sum(actual_bmc), category,period),Green()).