1 Reply Latest reply on Jan 24, 2014 9:49 AM by Tracy Rodgers

    Filter in one sheet based on attribute values in another sheet.

    shaheed shaikh

      Hi,

       

      Is there a way that I can filter the dimension values in one worksheet based on the attribute values in another sheet.

       

      For example, a dimension has total 10 values. In sheet 1 , due to its own filters, it show only 5 values. Can I filter another sheet, say sheet 2, based on only those 5 attribute values in sheet 1?

       

      Thanks,

      Shaheed