> For the complete documentation index, see [llms.txt](https://docs.bdb.ai/self-service-visualization-4/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.bdb.ai/self-service-visualization-4/design-canvas/create-calculated-field/creating-a-formula/summary-level-option.md).

# Summary Level Option

{% hint style="success" %}
*Check out the given illustration on how to create a Formula Field at the Summary level.*
{% endhint %}

{% embed url="<https://files.gitbook.com/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fq1Y2nC9XDrWcLwg1gpYr%2Fuploads%2FZ4dPo0dlCgvQuknUgh0S%2FSummary%20Level%20Measure%20Formula%20Field.mp4?alt=media&token=3945b0c3-a7b1-40da-be35-9cefc52969cf>" %}
Creating a Summary Level Formula Field
{% endembed %}

The user can also create a formula field choosing the ***Summary Level*** as a level option from the Formula field editor window.

* Navigate to the Design page of the report.
* Select the required fields to top bar. E.g., in the given image Offered CTC and Previous CTC are displayed for each employee.
* Click the ***GO*** option.
* The data appears for the selected fields. Select the Data Grid charting element to view the data.
* Click the ***Create Calculated Field*** icon.

<figure><img src="/files/SVzoKXkIZLV5jKlSnyDG" alt=""><figcaption></figcaption></figure>

<figure><img src="/files/Po1VCfH16rn7PL1wjKPH" alt=""><figcaption></figcaption></figure>

* The ***Create*** ***Calculated Field*** window appears.
* Navigate to the ***Formula*** tab (It is the default tab).
* Give a name to the new field.
* Choose ***Summary Level*** from the Level drop-down menu.
* Select a ***Save as*** option (It allows only ***Measure*** as the ***Save As*** option).
* Select fields using the Fields tab.
* Select an Operator from the Operators column.
* Enter a Formula Expression using the ***Fields*** and ***Operators***.
* Click the ***Save*** option.

<figure><img src="/files/CG6iakLRMDSFdlXOG3mc" alt=""><figcaption></figcaption></figure>

* A notification message appears to ensure that the Formula field has been created and gets added to the Data Store.

<figure><img src="/files/bCauiE4hpFFTGLkRrrVN" alt=""><figcaption></figcaption></figure>

* A new ***Formula Field*** gets created and added to the list of dimensions and measures.
* Add the Formula Field to the top bar.
* Click the ***GO*** option.
* The Formula Field data gets displayed in the current View for the users to validate the Formula.

<figure><img src="/files/jRV1G63qzjp1TjG7zot4" alt=""><figcaption></figcaption></figure>

{% hint style="info" %}
*<mark style="color:green;">Please Note:</mark>*

* *The **Summary level** Formula Field only gets saved as a **Measure**. It can't be saved as a Dimension to the Data Store.*
* Summary Level will not be listed for the space where the ***MongoDB*** server is configured in the ***Admin Settings***.
  {% endhint %}


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## 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://docs.bdb.ai/self-service-visualization-4/design-canvas/create-calculated-field/creating-a-formula/summary-level-option.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.