I have two unassociated tables, Opportunity and Lead. Both tables have fields like LeadSource, LeadSourceDetails, Owner, AssumedTerritory
I would like to have filters on the sheet that will filter both tables by separate fields so that the tables are not associated and return results based on the applied filter.
The outcome should be KPI numbers that are counted in each table based on the applied filter.
I tried something like this
[tmpLeadSourceTable]:
Load Distinct
LeadSource_lead as LeadSource
Resident Lead;
Concatenate([tmpLeadSourceTable])
Load Distinct
LeadSource_opp as LeadSource
Resident Opportunity;
[LeadSourceTable]:
LOAD [LeadSource]
,[LeadSource] as LeadSource_opp
,[LeadSource] as LeadSource_lead;
LOAD Distinct [LeadSource]
Resident tmpLeadSourceTable;
drop table tmpLeadSourceTable;
and this works but when I try to add another definition for next filed like this it show circular dependency.
