Hi,

I have a metric that does not make sense to be aggregated (number of subscribers on a given day). Instead, we'd want the metric to be always the value from the last day of the time period. For example, if I'm looking at a month level, I need the subscribers measure to be the value from the last day of the month. All the other measures in the cube can be aggregated, except this one. Is there a solution that already exists using MDX or something similar?

Thanks,
Vijay