Total average problem

[#1]

Hi Guys,

I have a little problem with an overall average an I hope you can help me out.

I have a line chart with 2 dimensions Time&Segment which looks like this:

When I flip this chart to a pivot chart it looks like this:

The values that are calculated are avg's ratings per segment. What I want to show in the Line chart now is the "Total" that is calculated in the pivot chart. This means the average over all segments per month.

If I enable the avg trendlines in the line chart I unfortunately only get flat lines per segment:

Hope I made myself clear and one of you is able to help.

Much appreciated}

Cheers,

Flo