-
SCOPE MDX total sum not updating when filtering
Hi!
I am using the following MDX to summarize the members of a calculated measure at the total level.
Example:
Time Call
A1 1 * 2 = 1
A2 1 * 3 = 3
A3 1 * 2 = 2
Total = 1 + 3 + 2 = 6
The problem is that when filtering to A1 and A2, it still shows 6 as the total. How could I update the MDX to make it update the total to 4 when filtering A1 and A2. Thanks!
MDX:
CREATE MEMBER CURRENTCUBE.[MEASURES].[AcdTimexAcdCall]
AS [Measures].[Call]*[Measures].[Time],
VISIBLE = 1;
CREATE MEMBER CURRENTCUBE.[MEASURES].[TotalAcdTimexAcdCall]
AS [MEASURES].[AcdTimexAcdCall],
VISIBLE = 1;
Scope ([Dim Agent].[Agent Name].[All], [MEASURES].[AcdTimexAcdCall]);
This = sum([Dim Agent].[Agent Name].[All].Children);
End Scope;
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|