# Create a new Report

## How to create a new report?

* Click on Analyze from the navigation bar and navigate to **Reports.**
* Click on “**+ Create Report**” to create a new report.
* On the Build Report Using page - Choose **Table,** to build detailed reports using tables from your data warehouse.
* The Create Reports form opens up. **Give a name** to your report.  
* Search and select the table from which you want to build the report.
* Click on **Create** 

## Build a Report from Table

Let's suppose we have an e-commerce orders table and we want to build some analysis around that, like Total sales by Product Category, Sales by state, etc.

* Click on "**+Create Report**" and select the e-commerce\_orders table
* On clicking on Create, you would land on the Edit View of the **Report Builder UI**.
* In the Input section, you can see all the columns that are present in the table.
* For example, let's build a table consisting of category-wise total sales value. The table is the default visualization type. 
* In the **Build** Section, **Table Fields** - there are two sections: **Summarize** and **Group By**.
* Drag *Bill\_value* into the **Summarize** area. You may also click on "**+Add Column**" to add a column. When you drop a numeric column, the summarization is by default selected as **Sum.** You may change the aggregation type. But for our example, we need the sum of total sales by category, let's leave the aggregation as Sum.
* Now drop *Category* into the **Group By** Area. 
* :zap: Hit the **Run** button.
* And there you have the Total Sales by Category in the table format.
* Now, for example, you want to plot a pie chart for the Total Sales by Category. Click on **Pie-Chart** Visualization type on the top of the pane.
* Make edits to the chart settings if required, and :zap: Hit **Run**. 
* And there you have the Pie chart of Total Sales by Product Category.
* Sample Output

<figure><img src="/files/spGl1EsIWbY71BU7in1z" alt="" width="524"><figcaption></figcaption></figure>


---

# 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://docs.sprinkledata.com/product/analysing-your-data/reports/build-using-tables/create-a-new-report.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.