3 Replies Latest reply on Nov 15, 2018 12:40 PM by Stephen Rizzo

    swapping sheets based on parameter does not show filters in hierarchical data

    Fisseha Berhane

      I have attached a sample notebook with the sample superstore data. I want to swap views based on time filter parameter. It consists of Month and Year. Further, I want the State and City dimensions to be added to the filter. I want the city filter to show only the cities in a selected state. Therefore, I have chosen "Only Relevant Values".

       

      My issue:

       

      When I change the time filter to Month, the city filter does not show any item. I see "No Items".  Can you help me understand what is happening and how to solve it?

       

      NB. If I do not make the city filter to show only 'Relevant Values', I do not have the 'No Items' problems but it shows cities that are not in the selected state as well.