Filter only 1 node from the level 3 in the hierarchy

[Jeka]

Hi,

I have a cross tab, using cube.

User can drill up and down in the crosstab.
Crosstab starts at level 2 of the hierarchy. then user can drill down to level 5.

Is it possible to filter only one node from level3 and anything under that node?
tuple(Local, Florida)
I dont need to see any transactions in that node that associates with Florida.
i still need to show this node.
Thank-you

[rockytopmark]

use the Filter() function.

My guess is you may also need to incorporate the Caption() function for your filter's check

Filter([State Level],caption([State Level]) <> 'FLORIDA')

perhaps EXCEPT() may also be used...

just ideas

[Jeka]

I cant get filter to work.

Any other ideas would be appriciated!

thank you