AVG monthly revenue per category

[dmk223]

Hello, 

I need a table with Product Category as dimension and avg monthly revenue.

I've tried something like this :

sum(Aggr(sum(({<shop={xxx}
>} [Revenue])), [MonthYear]))

But it doesnt work as it supposed to.  Im stuck at this and i have no idea how to solve this.

[BrunPierre · Accepted solution]

Like this?

=Avg(Aggr(Sum({$<Shop={'xxx'}>} Revenue), MonthYear, Category))