Straight Average Line to Pivot Chart

[johnbird1988]

Hello,

I am not sure if this is possible but does any one know how I can add a straight line showing the average in a Pivot Table Chart. I am not able to add the average to the source data because I want to use slicers for my charts and pivot tables. Is there a way I can do this with the calculate field or something.

Any help would be brilliant.

Thank you,

John