Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
sum(sales) / count(distinct month)
what about above?
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.
sum(sales) / count(distinct month)
what about above?
Thanks Vinieme12,
looks way smarter.