Skip to main content

Hello, 

 

I have implemented the territory model, and opportunities are assigned to a territory based on the account postcode. The hierarchy is set up with parent and child territories. 

An example is: 

Parent territory (Territory name) = Midlands  

Child territories (individual postcodes) = Midlands CV / Midlands DE / Midlands B1 / Midlands B2 etc 

 

Opportunities are assigned to the child territories.  

 

When creating reports, I want to report on the Parent Territory, but opportunities are assigned to the child so the report is grouping by the child and not the parent. The Parent is not an option because no records are assigned to it. 

 

 Example:

Help reporting on Opportunities with Territories

 

I can't bucket the column because the territory has more than 20 postcodes. 

 

Can anyone advise me on how I can achieve reporting by Parent Territory?

 

@* Salesforce Administrators *

 

Thanks 

2 respuestas
  1. 6 may 2025, 6:02 p.m.

    @Lorna Chew - this may be a report type issue.  I'm a little fuzzy on Sf's enterprise territory management feature, but you should be able to include Territory2.ParentTerritory in your report and then group by that.  If you're using a standard report type and don't see that relationship, you may need to create a custom report type so that you can include it.