Filter data and show in prompt

[Manu0521]

I have to show customers in a prompt based on specific regions. I dont want to use a detail filter. What should i expression be to achieve this.
Some thing like sacustomers  from east region where customer is a level and east is a higher level.

If I have two prompts in my report which i use only for filtering the data and I dont show it in rows or columns. How can my slicer condition be..will it allow me to give two conditions in my slicer.?

Thanks,

[MFGF]

I have to show customers in a prompt based on specific regions. I dont want to use a detail filter. What should i expression be to achieve this.
Some thing like sacustomers  from east region where customer is a level and east is a higher level.

If I have two prompts in my report which i use only for filtering the data and I dont show it in rows or columns. How can my slicer condition be..will it allow me to give two conditions in my slicer.?

Thanks,

Hi,

So you want to show countries within a specific region in your prompt? How is the region determined? If it's a fixed member, then the "use value" of your prompt would be a calculated expression such as

descendants([Your chosen region member], [Your countries level])

If you are prompting for the region also, then the expression would be

descendants([Your region hierarchy or level] -> ?YourRegionParameter?, [Your countries level])

The first part of this is driven by the expression you originally used to generate the Region prompt - could be the hierarchy or the level, or even something different.

MF.