Not aggregation by dimension

[Anonymous]

Good day!

Is  any way to solve such task.

I have pivot table with dimension Sales Point and YearMonth.

My expr: sum(Volume)/count(Distinct [Sales Point])

I need: sum(Volume) to aggregate by YearMonth,

           count(Distinct [Sales Point]) not aggregate by YearMonth

Thanks.

[Gysbert_Wassenaar]

Perhaps sum(Volume)/count(total <[Sales Point]> Distinct [Sales Point])

[tresB]

Like this?

sum( Total <[Sales Point]> Volume)/count( Total <YearMonth> Distinct [Sales Point])