You can see in my excel file, there are 3 columns which are "Sub Domain", "Functional Area", "Account" and "Domain Engagment".
In Domain engagement column, the values are C, P, O.
I want to display all the subdomain, functional area, account columns in QV as straight table which has status as 'c' and also have an opportunity ( domain status as 'O').
Please look at the attached excel file and given result.
I am not clear with your question but hope you are looking for something similar to below.
A where condition which will load only the Domain Engagement Status 'C' and 'O'.
LOAD [Sub Domain],
[Domain Engagment Status]
(ooxml, embedded labels, table is Sheet1)
where Match([Domain Engagment Status],'C','O');
you have to load your data as it is and use the Aggr function to find out which Account has both "Domain Engagement Status" as 'C' and 'O'.
Please find attached the solution file.
Solution.qvw 154.5 K