I would like to have a different aggregation for my measure based on the
level the user is. I mean, by default, the user is at the year level and I
want him to see the sum for the sales:
But when my user drill down to the week level, I would like him to see
an average. Is it possible ? I would also like to display this kind of
measure in DataAnalyzer. Hopefully it's possible. Thanks for any help.
Here's my cube definition :