Reference vs Duplicate - using subset of data from main query

Hi Anonymous ,

Based on this document about Reference and Duplicate query, When a query references a second query, it's as though the steps in the second query are combined with, and run before, the steps in the first query. So The Duplicate is as the same thing, combine the query manually. But reference queries can avoid the duplication of logic across your queries. 

It seems that you want to only get parts of data based on product type? Have you tried to assign native sql statement when connecting the data source, so that it will only retrive the nessary data from source?

We also cannot understand what you mean "can't add measures", measure is like a formula, does not store data and only calculate when nessary, are you meaning create calculated table or anything else?

Best regards,