# Visual-level formulas

<table data-header-hidden><thead><tr><th width="325"></th><th></th></tr></thead><tbody><tr><td><a href="/pages/2gpeveZIWZpzTm3xS5BK">Excel-like cell editing </a>(04:36)</td><td>Use the spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells</td></tr><tr><td><a href="/pages/oazdcFhELXImm0lTq8TZ">Quick formula options</a> (03:00)</td><td>Utilize the one-click options to insert columns such as % contribution to grand total, running total, ranking within group​</td></tr><tr><td><a href="/pages/TtKTQNpWOsTD8DsEmvr1">Smart analysis</a> (03:01)</td><td>Perform one-click contribution and variance analysis without using DAX</td></tr><tr><td><a href="/pages/X69NRbU7YZayNFrWpsJN">Excel-like formula editor</a> (04:21)</td><td>Leverage no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers</td></tr><tr><td><a href="/pages/xeI72ZNju3XMnOlTGaf8">Calculated measures and columns</a> (02:31)</td><td>Add custom calculations as columns and measures  without having to create new DAX measures or calculated columns in the data table</td></tr><tr><td><a href="/pages/eUg8uHRpv6hkeF0xnIDR">4 ways of inserting rows</a> (06:09)</td><td>Insert static, calculated, contribution and template rows in Power BI</td></tr><tr><td><a href="/pages/Gdw03hu4eE8qlShY1YHt">Evaluate column before rows</a> (01:49)</td><td>Configure the column total and subtotal calculations when inserting calculated rows</td></tr><tr><td><a href="/pages/kw2dpmBJd3B1YAUixV3N">Manage aggregations</a> (4:00)</td><td>Apply custom measure aggregations in a specific report (e.g., average quantity sold) instead of using the default aggregation</td></tr><tr><td><a href="/pages/hDNh2fZvXQiWpyWnbNc1">Automatic variance calculations (1:44)</a></td><td>View absolute and percentage variances in a single-click by simply assigning the measures to the correct fields</td></tr></tbody></table>


---

# 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://videos.inforiver.com/reporting-matrix/visual-level-formulas.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.