Highlighting data x location which does not meet a specified target

Hi, I have created a pivot table with a formula 'Weekly Target Flag' which highlights locations which have not met their weekly target of safety Observations.

The problem is to get the data to highlight I need to add the formula as a column. The information then appears in the table. How do I create a formula which does not appear in the table or how do I hide the column information 'Weekly Target Flag'?

(photos: Analyzer and formula attached)

Best Answers