Questions tagged [cross-filter]
Cross-filtering allows a report to filter an object by its children objects, such as only showing Accounts with Opportunities.
14
questions
0
votes
0
answers
46
views
How to filter to latest date of Opportunities on an Account
I’ve spent a good amount of time trying to figure out or find this answer -
I created a report showing fields from both Accounts and Opportunities and there are sometimes multiple Opportunities tied ...
0
votes
1
answer
387
views
Cross filter with a date not working
I'm trying to create a report showing me the accounts without contract for 2022 year
I selected :
all accounts
created date : all time
Cross filter : accounts without contracts, start date less or ...
- 1
0
votes
1
answer
518
views
Report Cross-Filter on Lookup . Looking for a standard solution
the scenario is the following one:
My client wants to be able to report his opportunities based on the Account Segmentation
I cannot create new fields because we are in a system used by different ...
0
votes
0
answers
72
views
Filtering users out in a journey via values housed in separate DE
GOAL: Create a API event journey that filters users out based off of values passed in the API call when compared against matching values in matching fields in a separate data extension.
I have a ...
- 1
0
votes
1
answer
183
views
How can I report all accounts that don't have any CampaignMembers for a specific campaign?
I have a request for reporting on all accounts that don't have at least 1 contact that is a Campaign Member on a specified campaign, but I'm struggling to build this report.
It feels like cross ...
- 970
2
votes
2
answers
624
views
Unable to find a field 'Product Code' for a sub-filter, under a Cross filter of Opportunities with product
I have this Report, of standard report type "Opportunities". I have added a cross filter "Opportunities with Products"
But I'm unable to find the standard field "Product Code" to be used in Sub-...
- 129
0
votes
0
answers
42
views
Unable to create reports based on activities in sfdc
I got a requirement like to create reports for activities.i have user able to view all accounts and Opportunities.But he can't able view all activities while creating reports.I don't where it will not ...
- 1,439
2
votes
1
answer
183
views
Campaign Exclusion Report
I am having trouble creating a Campaign with Leads report and could use some help.
I have Salesforce Enterprise edition.
I have a population of 324 leads that are all campaign members of Campaign A....
- 23
1
vote
2
answers
406
views
Report cross object filters: pulling only parents with multiple types of cross object children
Sorry if the wording is confusing, let me explain:
Our Account object is (indirectly?) a parent of the Asset objects, so it is possible to run a cross object filter on Accounts with Assets, and to ...
- 3,762
1
vote
1
answer
841
views
Cross Filter Disabled For Report with Master Detail Custom Report Type
We have a custom report that uses a custom report type but when we try to add a cross filter on the report the option is greyed out / disabled.
The custom report type has a relationship from ...
- 363
3
votes
2
answers
1k
views
Filter on Accounts that currently have one product but not another
I need a report that will list out all of our Accounts currently under contract and use one product, but do not have another. I feel like there might be an easy way to do this and that I am possibly ...
- 149
2
votes
0
answers
160
views
Cross filter trouble | unable to select a parent where there are no grandchildren of a certain type
I have a challenge: I want to be able to find the parent objects that do NOT have records of grandchildren of a certain type.
To illustrate the challenge: I have the following objects in Salesforce: ...
- 5,237
0
votes
1
answer
3k
views
Contact Activity Report (or Contact report with Activity Cross-Filter)
Does anyone know of a way to gather Contacts without activities within a certain time frame (ie: 30 days) and not assigned to a specific user?
I've tried a Contact report with the cross filter of "...
- 30
2
votes
2
answers
14k
views
How to cross-filter joined reports?
As of Summer '12, joined reports do not support cross filters and I'm wondering if there is a way to work around it.
Example:
I have a custom objects for Events, Events Attended, and Work History. ...
- 13.3k