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