# How to Pivot and Group on the Valuations Screen

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

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

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/o5w4ezeglr/1689265015270/file-am-lk-rgdeg-d.png" alt="" width="188"><figcaption></figcaption></figure></div>

#### Grouping on a Detailed View <a href="#grouping_on_a_detailed_view" id="grouping_on_a_detailed_view"></a>

Once you're under your desired view, click on the purple column picker on the right-hand side of the screen.

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/o5w4ezeglr/1689265015480/file-yctc-os-6-v-da.png" alt="" width="375"><figcaption></figcaption></figure></div>

Then, you can choose the columns you'd like to include in your view.

**TIP**: You can scroll or use our search bar for quicker access.

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/o5w4ezeglr/1689265015717/file-ipl-bx-7-h-slo.png" alt=""><figcaption></figcaption></figure>

Drag columns by holding down the grid symbol to the left of the name and moving them to the **ROW GROUPS** section. Once you do, a field should populate under your view tab, as shown above.

Once you've added columns under **ROW GROUPS,** you can add columns under the **VALUES** section.

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/o5w4ezeglr/1689265016076/file-6-byl-6-q-wvsj.png" alt=""><figcaption></figcaption></figure>

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

**TIP**: If columns aren't appearing in the table, make sure the column check box is clicked on the column picker.

The default aggregation method is a summation. If you'd like to change the aggregation, click on the item in the column picker, i.e. **sum(Contract Quantity).**

A list should auto-populate, as shown below:

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/o5w4ezeglr/1689265016370/file-ek-5-wm-ls-si-2.png" alt=""><figcaption></figcaption></figure></div>

You can scroll and choose your desired aggregation method.

#### Pivot Mode <a href="#pivot_mode" id="pivot_mode"></a>

To pivot, toggle on **Pivot Mode** at the top of the column picture:

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/o5w4ezeglr/1689265016616/file-7-s-gja-3-tg-8-s.png" alt=""><figcaption></figcaption></figure></div>

This **COLUMN LABELS** field should populate at the bottom of the column picker:

<div align="center"><figure><img src="https://files.helpdocs.io/56bu62syz9/articles/o5w4ezeglr/1689265016834/file-4-g-3-gb-cf-3-vx.png" alt=""><figcaption></figcaption></figure></div>

Once you've dragged your column label, it should populate at the top of your table, as shown below:

<figure><img src="https://files.helpdocs.io/56bu62syz9/articles/o5w4ezeglr/1689265017060/file-zndb-ys-9-i-1-u.png" alt=""><figcaption></figcaption></figure>

That's it! We hope this will save you some time. If you have any questions, please let us know at <support@molecule.io>.

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