I am not sure I understand but I will give it a shot. If you want your formulas to be based on the territory for example, you can add the territory dimension as either a page break or a level in the excel tempale.
If it is added as a page, you will then get a seperate tab in the Excel report for each territory
If you add as a level, your formalas would repeat for each level, which is based on terrotory
Some articles that may help you are
As Adam noted, use "Page" or "Level" to create a worksheet or section for each value of a dimension.
If you want to create a section for each value of multiple dimensions then in Excel you must use a level (Country + Year would render something like France - 2000; France - 2001... Germany - 2000; Germany - 2001...).
In PowerPoint, you can use Page to create a slide for every value of a single or multiple dimensions.
All of these techniques will show all values of the dimension you are using unless you use a separate filter to remove those values you don't want to show.
This can only be done vertically (up and down a page), not horizontally (across the rows of a page).