SQLTeam.com | Weblogs | Forums

Change Total-Value on SSAS Hierarchy


#1

I have the agregate function "distinct count" on a hierarchy-level (Week from Mon-Sun). The total value also shows the "distinct count" over all days. Now I would however the total value the value from Sunday assign. I think with MDX should this be possible?
Regards
Nicole