Skip to Content
0
Former Member
Feb 24, 2009 at 06:32 AM

Bex Formulas and filters issue

26 Views

Hi,

I have a question on filters.

I have item in my cube and values as 1,2,3 etc. sometimes only 2,3 (no 1).

i need to filter the report in such a way that if item is 1 then filter on it if there is no item 1 then filter on 2 and so forth.

I am using formula bycreating rkf item1 and item2

(Item1 > 0)(Item2 == 0)Item1 + (Item2 > 0)(Item1 == 0)Item2

but it'snot working as expected

say for item1 notifications 1,2,3

for item 2 notifications 1,2,3,4,5

what i want from this is when item 1 display 1,2,3, and when there is not 1 then display 4,5(for item2)

but by this formula for item 1 i am getting 1,2,3, and for item 2 1,2,3,4,5, but i need only 4,5 for item 2 how can we acheive this.

Thanks,

Nav