How to hide detail lines when wanting to show just average in chart

[gerrycastellino]

How do I show just my average in the chart instead of the 2 numbers that are displaying.

Gerry.

[sunny_talwar]

Something like this:

=If(Dimensionality() = 0, Avg(Aggr(Sum(VALUE), DIM)))

Replace Sum(VALUE) with your current Expression and DIM with all your dimensions in the chart.