# How to Pivot and Group on the Valuations Screen

Once you've [created a view](/core-functionality/core-features/specialized-features/trades/valuations-screen/how-to-use-the-valuations-screen.md), you can group and aggregate it for collapsible and expandable trade-level detail.

First, go to the **VALUATIONS** screen from the main menu.

<img src="/files/c913dad714ff23bed5226652dd9ceca536af6f8b" alt="" width="375">

{% stepper %}
{% step %}

#### Grouping on a Detailed View

1. Open your desired view, then click the purple column picker on the right-hand side of the screen:

   <img src="/files/7e7023159391e3548ae5e8fb946fc5a668a535a7" alt="" width="375">
2. Choose the columns you'd like to include in your view:

{% hint style="info" %}
TIP: You can scroll or use the search bar for quicker access.
{% endhint %}

![](/files/61a00c68985265c5d83e2b105c3e0aac4d8e4bb5)

3. Drag columns by holding the grid symbol to the left of the name and move them to the **ROW GROUPS** section. A field will populate under your view tab.
4. After adding columns under **ROW GROUPS**, add columns under the **VALUES** section:

![](/files/034abc0b8f84d40c9315e51b25c83ab5f807248e)

3. As you drag items, columns will be added to your table in Molecule.

{% hint style="warning" %}
If columns aren't appearing in the table, make sure the column checkbox is selected in the column picker.
{% endhint %}

6. The default aggregation method is a summation. To change the aggregation, click the item in the column picker (for example, **sum(Contract Quantity)**). A list of aggregation options will appear—choose the desired method:

![](/files/050894c24624cf10c9d0a71cf988506d6fed4dda)
{% endstep %}

{% step %}

#### Pivot Mode

1. Toggle on **Pivot Mode** at the top of the column picker:

   ![](/files/b1195a5e8a36970e14692dd65d129d8545739926)

2. The **COLUMN LABELS** field will appear at the bottom of the column picker:<br>

   ![](/files/6fbd312e6efdd1ccab8f013ee96e43331d59db6d)

3. Drag your desired column label into **COLUMN LABELS**. It will populate at the top of your table:

<div align="center"><img src="/files/00f10ee2f1ee83b2974f37b7848afd82fd868797" alt=""></div>
{% endstep %}
{% endstepper %}

That's it! If you have any questions, please let us know at <support@molecule.io>.

See related: [How to use the Valuations Screen](/core-functionality/core-features/specialized-features/trades/valuations-screen/how-to-use-the-valuations-screen.md).


---

# 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://help.molecule.io/onboarding/welcome-and-getting-started/how-to-use-the-valuations-screen/how-to-pivot-and-group-on-the-valuations-screen.md?ask=<question>
```

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.