Power Mode

Power Mode is the extended grid for the requests in a custom view in Capex Management. Each row is a request and each column is a request field, so you can filter, sort, group, total and edit many requests without opening them one by one. This page covers how to open Power Mode, how to work with the data in the grid, and which of your changes Weissr remembers.

💡 Tip: Power Mode suits you when you need to slice and dice request data or manage a large number of requests at once.



Opening Power Mode

Power Mode is one of two ways to show the requests in a custom view. Use the Power mode and Default mode toggle in the toolbar of the request list to switch between them. Weissr saves your choice for your user, so the next view you open uses the same mode.

A Superuser creates each custom view and sets its default filter and layout. The filter decides which requests you see and in which order, and the layout decides which columns the grid starts with. From there you can personalize the grid for yourself.

👉 Learn more about custom views


Reading the Power Mode grid

  • Each row is one request. The request name column and the row menu with the request commands are fixed on the left.

  • A lock icon on a row means another user is editing the request, and you cannot edit it until they are done.

  • Closed requests have their own row color.

  • When a calculated value cannot be calculated, hover over the cell to see the error.

  • The grid is split into pages. Choose 5, 10, 15, 20, 50, 100, 200 or 500 requests per page at the bottom of the grid. The page size is remembered in your browser.


Filtering and sorting in the grid

On top of the standard filter of the custom view, the Power Mode grid has its own column filters and sorting. Use them to narrow down and order the requests directly in the grid.

👉 Learn more about standard filters and sorting

Filter row

The row below the column headers holds a filter field for each column. The grid updates as you type.

  • Text columns: contains, equals, does not equal, starts with or ends with.

  • Number and date columns: equals, does not equal, less than, greater than, less than or equal to, greater than or equal to, or between.

  • Dropdown columns: no filter field. Use the header filter instead.

Header filter

Click the funnel icon in a column header to open a list of the values in that column. Select or clear values to include or exclude them. Dates are grouped by year.

The header filter is available on most columns. Decimal and money columns have only the filter row, and table and image columns cannot be filtered.

Click Clear filters in the toolbar to remove all column filters at once.

image-20250807-150243.pngimage-20250807-150407.png

Sorting

  • Click a column header to sort ascending, and click again to sort descending. Sorting on another column replaces the previous sort.

  • To sort on several columns, right-click each column header in turn and select Sort Ascending or Sort Descending. The grid sorts in the order you applied them: the first column you sorted comes first, then the next.

  • To remove the sorting from a column, right-click its header and select Clear Sorting.

  • Image, model, rank, hyperlink and table columns cannot be sorted.

📌 Note: When the filter of the custom view has a sorting rule, sorting from the column headers is turned off and the grid uses the sort order of the filter.


Grouping requests

You can group requests by one or more columns, for example business unit, cost center or request status. Each value becomes a group header row, with the requests that share that value listed underneath. Grouping several columns at once nests the groups.

How to group requests

  1. Right-click a column header.

  2. Select Group by This Column.

  3. To add another level, repeat the steps on another column.

image-20250423-075909.png

How to ungroup

  • One column: right-click the group row and select Ungroup.

  • All columns: right-click any group row or column header and select Ungroup All.

image-20250423-080037.png

Which columns can be grouped

You can group on most system and dynamic fields. These field types cannot be grouped, because they hold amounts, links or visual content rather than categories:

  • Money

  • Hyperlink

  • Image

  • Model

  • Rank

  • Table

Outlay year columns cannot be grouped either.

Group totals

When Show totals is turned on in the Power Mode settings, each group row shows the totals of the money columns and outlay year columns for the requests in that group.

  • Totals cover every request in the group, also those on other pages of the grid.

  • Totals are shown in your default currency and number format.


See how requests relate to each other NEW IN 5.3.7

Requests are often connected to other requests. Some belong to an investment program, and some are additional requests that move funds between projects. Three read-only columns show these connections in Power Mode, so you no longer need to open each request to see where it belongs.

Each column shows the related request by its name. The column reads the stored connection, so when the related request is renamed, the column shows the new name.

Column

What it shows

When it is blank

Investment program

The name of the investment program (main request) the request belongs to. A main request shows its own name.

The request is not part of an investment program.

Parent request

The project an additional request was created for: the project that gets the extra funds with Request More Funds, or the project the funds are taken from in a reallocation or transfer.

The request is not an additional request.

Beneficiary request

The project that receives the funds in a reallocation or transfer.

The request is not a reallocation or transfer.

To add a column, open Fields and select it under Available fields. You cannot edit these columns in the grid.

Tell which kind of additional request it is

Use the Parent request and Beneficiary request columns together:

  • Only Parent request is filled in: a Request More Funds request.

  • Both columns are filled in: a Reallocate Funds In or Transfer Funds Out request.

  • Both columns are blank: an ordinary request.

👉 Learn more about additional requests

Group, filter and sort on relationships

The relationship columns work like other Power Mode columns. You can filter, sort and group on them, save them in a layout, and export them to Excel with their grouping. Like other dropdown columns, they are filtered with the header filter.

For example, group on Investment program to see every program as its own group, with its requests listed underneath. Turn on Show totals to see the sums for each program.

Grouping and filtering use the related request itself, not only its name. Two investment programs that share a name stay as two separate groups, and as two separate entries in the header filter.

📌 Note: When you group on Parent request or Beneficiary request with Show totals on, the amount of a reallocation or transfer is counted on both sides. Group sums are plain totals of the requests in each group.


Editing request data in Power Mode

You can edit request fields directly in the grid, without opening each request.

  • Editable cells get a slightly darker background when you hover over them. Number, money, text and dropdown fields also show a pencil icon.

  • Click a cell to edit it, and press Tab to move to the next cell.

  • Some changes ask you to confirm before they are saved: changing the budget year of a request that is in an approved budget, shortening the analysis period, and changing the forecast start date.

image-20250423-081443.png

When fields are read-only

A field can be read-only because of:

  • The field type, for example image, table or calculated fields.

  • The request state. Each field can be set to be editable only in some states, such as Registration, Execution or Follow-up.

  • Your permissions for the field or the request.

  • A lock: another user is editing the request.

  • A field-specific rule, for example the route cannot change once the request has left Draft, and the model cannot change on an additional request.

Editing outlays and cash flow

Outlays and investment model data have a time dimension, so you edit them in the request itself rather than in the grid.

  • Double-click a row to open the request in a new browser tab.

  • Click the request name to open the request in the same tab. Press Ctrl (or Cmd on Mac) while you click to open it in a new tab.

Field descriptions

Hover over a column header to see the field name and its description. This helps you check what a field expects without leaving the grid.

image-20250430-081530.png

Choosing fields

Click Fields in the toolbar to choose which request fields are shown as columns. The list is split into Fields in this view, Required fields (when your organization has any) and Available fields. Use the search box to find a field by name.

Jump to a field

  1. Make sure the field is in the view, through a saved layout or by adding it in Fields.

  2. In Fields, click the name of the field.

The grid scrolls the column into view on the left side of the screen.

💡 Tip: This saves time in wide layouts, where scrolling sideways to find a column is slow.

Quick navigation to a field.gif

Outlay year columns

The grid can show financial figures as separate columns per fiscal year and phase, for example:

  • FY2026 • Pre-decision outlay

  • FY2026 • Decision amount

  • FY2026 • Post-decision outlay

These columns are hidden by default. Click Outlay years in the toolbar and select the columns you want. You can choose from five fiscal years, and as in Fields, you can search the list and click a name to jump to the column.

📌 Note: Outlay year columns cannot be sorted, filtered or grouped, and they are not saved in layouts.


Layouts

A layout is a saved set of fields and their order. Apply a layout to switch the grid to those columns. A layout does not store column widths, fixed columns, sorting, grouping, filters or outlay year columns.

In the Layouts menu you can:

  • Save the current columns with Save current layout.

  • Apply, edit or delete a layout. The layout in use is marked as Applied.

  • Save a layout as private, for yourself, or public, for everyone.

🔒 Only users with the Capex Management administrator permission can save a public layout.

💡 Tip: Layouts are useful when many fields are available and you want to switch between a few focused sets of columns.

image-20250807-150821.png

Power Mode settings

Click the gear icon in the toolbar to open the grid settings. The two toggles are saved for your user and apply in every view.

Word wrap enabled

Wraps long cell values over several lines, so you can read the whole value without widening the column. Column headers do not wrap. This setting is off by default.

Show totals

Adds a grand total row at the bottom of the grid for all money columns and outlay year columns, and shows group totals when the grid is grouped. This setting is on by default.

⚠️ Warning: Totals are calculated on the server each time the grid loads. With many requests, turning off Show totals makes the grid faster.

Restore defaults

Click Restore defaults to clear your changes to the current view: column order, visibility, widths, fixed columns, sorting, grouping and column filters. The grid returns to the default set for the custom view.

👉 Learn more about restoring default view settings

image-20250403-081432.png

Arranging columns

  • Drag a column header to move the column.

  • Drag the edge of a column header to change its width.

  • Right-click a column header to fix the column to the left or right. Fixed columns stay visible while you scroll sideways.

What Weissr remembers for each view

Weissr saves the state of the grid for your user and for each custom view separately. When you come back to a view, it shows:

  • Column order, visibility and widths

  • Fixed columns

  • Sorting

  • Grouping

  • Column filters

The Word wrap and Show totals settings are saved for your user across all views, and the page size is saved in your browser.


Currency display

Money values show a currency code. Which currency is used depends on your user settings:

  • With Use local currency if possible turned on, each request shows its money values in the currency of the request.

  • Otherwise, money values are shown in your default Currency.

  • Grand totals and group totals always use your default currency, because they add up requests in different currencies.

  • While you edit a money cell, the value is shown in the currency of the request.


Exporting to Excel

You can export the Power Mode grid to an Excel file. The file contains:

  • All visible columns, including outlay year columns.

  • All requests that match your filters, from every page of the grid.

  • Your grouping, as Excel outline groups. Group rows hold the totals of the money columns and outlay year columns.

  • Your column widths. Columns fixed to the left become frozen panes.

Totals are written as values, not as Excel formulas.

📌 Note: The total row at the bottom of the file covers the outlay year columns only. Money field columns have totals in the group rows, but no grand total. If no requests match your filters, the export stops and asks you to select at least one request.