> For the complete documentation index, see [llms.txt](https://docs.phocassoftware.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.phocassoftware.com/flex-modes/explore-your-data/view-transactions.md).

# View transactions

View and analyze the individual transactions that make up your data.

Transaction view shows transaction-level data. Use it to investigate the transactions behind the values in your analysis or work directly with individual transactions.

Transaction view and [Transaction mode](/flex-modes/change-your-analysis/switch-modes/transaction-mode.md) use the same transaction workspace, but you can open it in different ways depending on what you want to investigate.

### Open transactions

Choose how you open Transaction view based on what you want to investigate.

1. Select the **Transaction view** tab at the bottom of the grid to view the transactions behind your current analysis. Your filters and period context carry across.
2. Select **Transaction** from the mode menu to work directly with transaction-level data. Any filters you've already applied also carry across.
3. Right-click a value in the grid and select **Transactions** to investigate the transactions behind that specific value. Transaction view opens in a new browser tab and is filtered to the selected value, so your original analysis remains open.

<div align="left"><figure><img src="https://2122657374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaDGOWDU4SqRSiSPGXHgW%2Fuploads%2Fnwz81xIcPt2LIE4EbECx%2FScreenshot%202026-09-10%20at%2014.31.46.png?alt=media&amp;token=f51979f1-34b6-4588-8637-5b1173f01843" alt="" width="563"><figcaption></figcaption></figure></div>

When you open the **Transaction view** tab from another mode, the period setup is retained. For example, if you're working in Variance mode, Transaction view uses the primary period.

### Choose what to display

In Transaction mode, the panel on the left contains the properties you can add to the grid.

<figure><img src="https://2122657374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaDGOWDU4SqRSiSPGXHgW%2Fuploads%2F2YZdKdLZXDG70XMYZ10r%2FScreenshot%202026-09-08%20at%2013.52.36.png?alt=media&amp;token=48daba31-5fbe-4a39-9fa8-38272389f265" alt=""><figcaption></figcaption></figure>

Transaction properties, such as the transaction date, invoice number, and transaction ID, display at the top of the panel. The dimensions in your database display below them. Select the chevron next to a dimension to expand it and see its properties.

Select the checkbox next to each property you want to include. The selected properties display as columns in the grid, so you can combine transaction properties with properties from different dimensions in the same view.

For example, you might display the invoice number, customer name, Ship To name, Sales Rep, and product name alongside measures such as Value and Cost.

### Nest transactions

Use Nest view to group related transactions by a transaction property or a property within one of the available dimensions.

Drag a property into the **Nest view** area to group the transactions by that property. Add more properties to build a multilevel hierarchy, then expand the rows in the grid to explore the transactions within each group.

For example, nest by invoice number to group the transactions for each invoice, then add another property to break the transactions down further. You can display other properties, such as customer name and product name, alongside measures such as Value and Cost.

Properties that aren't used for nesting remain as columns in the grid.

<figure><img src="https://2122657374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaDGOWDU4SqRSiSPGXHgW%2Fuploads%2FnPXDgqKIS6FtPy4dIu3Y%2FScreenshot%202026-09-10%20at%2015.28.28.png?alt=media&amp;token=81faf858-97eb-496e-b028-660da42cdf06" alt=""><figcaption><p>Transactions grouped by invoice number with Nest view</p></figcaption></figure>

### Add calculations

Add calculation columns when you want to analyze your transaction data further. For example, you could calculate the value of a 5% rebate or discount for each transaction.

See [Manage columns](/flex-modes/customize-the-grid/manage-columns.md) for more information about creating and working with calculation columns.

### Search and filter transactions

To quickly narrow down the transactions, right-click a value and select **Focus** to keep only matching transactions. You can also choose from other filter options in the right-click menu to drill down further, depending on the selected value. Any filter you apply displays in the filter bar and can be managed in the [Advanced filter](/flex-modes/explore-your-data/filter-data/create-advanced-filters.md) pane&#x6C;**.**

You can also use the search bar to search transaction properties, such as an invoice number, or use advanced filters to create more specific filter rules.

Filters remain applied as you switch between modes and views. You can also filter by transaction properties in Transaction view and return to Grid view with those filters still applied. This allows you to analyze the filtered data in Grid view using transaction properties that aren't available there.

Filters on transaction properties are identified by a **TRANSACTION** tag above the grid.

<div align="left"><figure><img src="https://2122657374-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FaDGOWDU4SqRSiSPGXHgW%2Fuploads%2FAi9Gr9Y9Wgi9LN33WTH6%2FScreenshot%202026-09-16%20at%2014.25.24.png?alt=media&amp;token=1c45598b-456c-4695-a8f0-5149b5657b0b" alt="" width="262"><figcaption></figcaption></figure></div>

If you've applied multiple filters, select **Clear** to remove them all.

See [Filter data](/flex-modes/explore-your-data/filter-data.md) for more information about creating and managing filters.


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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, and the optional `goal` query parameter:

```
GET https://docs.phocassoftware.com/flex-modes/explore-your-data/view-transactions.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

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.