Hi, 

I am looking at adding a dynamic threshold for an entire table on a chart report. 

For example our target is £30,000 the required average total sales is £1000 per day, however this isnt always the case for obvious reasons such as the weekend, weaker days etc, so What I want is this threshold to change in line with the daily sales in line with what is required - eg £1200 per day or £800 per day. 

Any Ideas around this?