1 Reply Latest reply on Dec 20, 2016 2:49 PM by diego.medrano

    How to hide sheet for which filter selected is not applicable?

    Sampat Kumar Reddi

      Hi,

       

      I am building an Executive dashboard which have bunch of metrics out of which not all are at same level. These metrics come from multiple sources.

      Eg: No. of sales is at Date>>Category level.

            No. of customers is at Date level

      Filers available for this dashboard are Month,Week & Category.

       

      What I am trying to achieve is that, when a user does filtering on "Category", the metrics which are not at category level shouldn't show up.

       

      Is there any way to achieve this?

       

      Thanks in advance

      Sampat