2 Replies Latest reply on Jul 5, 2018 8:35 PM by Lakshmi A

    union query with multiple data sets and filter issue

    Lakshmi A

      Hi,

      I have combined two different data sets with a union query with data set type that distinguishes the data. But when i try to apply a filter on the column which is present in one data set only the other data set goes away.

      I tried with LODs with no luck. Is there a way to display the table with Capacity data ignoring HC type filers?

       

       

      Sample workbook attached.

       

      Please let me know your valuable suggestions.

      Thanks,