6 Replies Latest reply on Oct 19, 2012 7:20 AM by chaitanya kaita

    How do I use parameters to include the dimension but exclude another dimension

    chaitanya kaita

      Hi All,


      Here is an example of my issue,


      I have attached a workbook that I have created as an example.


      I have created a parameter to exclude the State from the view. But at the same time I would also like to exclude the other regions from that view. Could you please help me figure out this issue.



      I have created a parameter "Show me view" to include and exclude values on the state  IOWA belongs to central region. So the parameter should behave in such a way that when I select IOWA, it should exclude IOWA from the central region at the same time exclude "EAST", "WEST" & "SOUTH" regions too.


      So, finally it should show only central region values excluding IOWA.