Wednesday, March 7, 2012

MDX query question

Here is the content of my source table.

IND_ID CALL_ID

1 1

1 2

2 3

2 4

3 3

3 4

4 7

I would like to create a measures which return the number of IND_ID with 2 element in the group for exemple

Call #2 times

2

Call #1 times

1

could u help me please !


Sorry, but I'm kinda confused about what you are trying to return. Could you describe the logic in a little more detail or possilby even write a SQL statement to show us what it is you are trying to achieve?

Thanks,
Bryan

No comments:

Post a Comment