# \[Advanced] Dimension Path When your database has complicated joining paths between tables and each joining path gives you a different result with different need, you can change to the needed path on Presight. You can check the sample schema below:

In the example, if you need to breakdown Invoice Amount by city, which path you want it to breakdown? City through Customer table or City through Seller table. Presight allows you to choose the needed one. If you want to see if the amount coming from which Seller City, choose the path going through Seller table, if you want to check how much from Customer City, choose the path going through Customer table. ### How to use #### Case 1: when there are more than one path with the same table numbers to go through When there are more than one path with the same table numbers to go through, a pop up will appear to ask which path you want to use. Then just choose the one you need and click **Select Dimension**

#### Case 2: when the dimension path is automatically choosen by Presight, the pop-up does not show up. Most of the time, Presight will automatically choose the shortest path for you when breaking down a metric. However, you can choose another path based on your certain needs. Then, you can right click on the dimension name, and choose **Change to a different \[Dimension name]**.

A dimension path list will pop up and allow you to choose to another one.

### Preferred Path You can set a preferred path to be the default each time you break down a dimension by ticking on "**Set this as Preferred Path from Orders to Customers**".

Some dimension paths are complicated, going through many tables. Setting Preferred Path can help your team members quickly breakdown to the correct dimension path. --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://presight.gitbook.io/presight-v1.0/analysis/breakdowns-and-filters/advanced-dimension-path.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.