Back	Home > Data Dictionary > G > Group By/Then By (Trade Review)

Group By/Then By (Trade Review)

You can group trades on the Trade Summary and Trade Review by any column heading. For example, you can group by Action so that all sells are grouped, all buys are grouped, and so on.

The following columns can show subtotaled values when this option is selected: 

Commission Difference Dollars Difference Percent (Absolute) Difference Percent (Relative) Difference Shares Dollars Initial Shares Initial Dollars Initial Percent Initial % of Category (DT) LT Unrealized Gain LT Realized Gain

Model Deviation Model Dollars (Adj) Model Shares (Adj) Percent of Account Traded Post Rebalance Dollars Post Rebalance Percent Post Rebalance Shares Realized Gain Percent Shares ST Realized Gain ST Unrealized Gain Transaction Fee

To group trades on the page, follow these steps: 

1. Click . This opens the Edit Columns and Display Options dialog box.

2. Under Display Options, choose the columns you want to group by. You can group by one, two, or three columns. Also choose if you'd like those columns sorted in ascending or descending order.

   

3. Select any of these options, if desired:

   • Show subtotals.Select this option to show subtotaled values for the grouped trades.
   • Only show securities with buys or sells.Select to only show trades in which buys or sells are recommended. When cleared, you can see all positions without recommended trades.
   • Show model-level detail.Available on the Trade Summary only. Select to show the trades split out by Security Level model.

4. Click Save.

For more information, see Learn More About Reviewing Rebalances and Trades.