value aggregation dependence on drill down dimension

[fe-c]

Hello everybody, 

is it possible to change the value aggregation (in a bar chart) in dependence of drill-down "status"?

For example: 

1st level of drill-down = year --> should show the average sales per month

sum(sales)/12

2nd level of drill-down = month --> I want the sum of sales per month

sum(sales)

 Is something like this possible in general?

Thanks in advance.

[fe-c]

Ok,  I think a have found a solution by myself. 

sum(sales)/((max(month(date_sales)))/(min(month(date_sales))))

Maybe this is not the smartest solution, but seems working like I want. Sure, it's not a bulletproof solution (e.g. years with no sales in january), but this is no problem in my dataset.

[vinieme12 · Accepted solution]

sum(sales) / count(distinct month)

 what about above?

[fe-c]

Thanks Vinieme12, 

looks way smarter.