This is probably pretty novice, but im having an issue making a parameter. I will try to explain the situation as best as possible. I work in non profit, there are 3 fund type 2's - 10, 20 and 30. I want all funds within fund type 1 = 10 and fund type 1 = 20, but I only want fund Level 2 = 300000 from fund type 1 = 30. Below is a visual representation of the hierarchy. Please let me know what I can use to do this. Thanks!
Fund type 1 | Fund Type 2 | Fund Level 1 | Fund Level 2
10
11
100000
100000
100001
100002
150000
150001
12
...
20
...
30
31
300000
300000
Hi,
Is this a filter?
[Fund Type 1] in (10,20) OR [Fund Level 1] = 300000
Does this give you the correct data returned?
Is this a dimensional or relational package by the way (ie do you see dimensions and hierarchies or Query Subjects and Query Items)?
MF.
Ah, I was way over thinking it. That works. Thanks