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


      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.