Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How do I show just my average in the chart instead of the 2 numbers that are displaying.
Gerry.
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.