Bex Formulas and filters issue

[Former Member]

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

[Former Member]

Guys any idea about how to acheive this.

Thanks,

Nav

[Former Member]

It lookslike else is not working properly, If item is 1 give the result for that item else how 2.

but here if item contains 1 and 2, it's giving 1 and dnot exiting the logic it's even showing 2 any idea where i am going wrong or this logic works like this only.

Thanks,

Nav