GetCurrentField

[MK_QSL]

I have cyclic group named Selection with below dimensions...

CustomerName

Item

Brand

Want to use this cyclic group in bar chart for with there is a reference line showing average sales.

What is wrong in below? It's simply not working !

Avg(Aggr(SUM(InvoiceValue),GetCurrentField(Selection)))

[MK_QSL · Accepted solution]

Sorted out...

Avg(Aggr(SUM(InvoiceValue),$(=GetCurrentField(Selection))))