# Options for totals

By default, grand totals do not display when you view a report as a pivot table. Also, totals never display when you view a report in chart format.

![Grand total options](https://698418877-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2Fgb0b8jIz4HuPLxqQR6C4%2Fuploads%2Fgit-blob-498f34bd0e75fbefd5d23b26fb9d2e49c9c05e11%2FPUC_Analyzer_Dialog_ReportOptions_03_TotalsArea_w533.png?alt=media)

Below are the options for showing and hiding grand totals for rows and columns.

* **Grand totals for rows**

  Select to display grand totals for rows in your report.
* **Grand totals for columns**

  Select to display grand totals for columns in your report
* **Totals with filtered values**

  Select to display totals which include [filtered values](https://docs.pentaho.com/pba/9.3-analytics/pentaho-analyzer-cp/adding-filters-to-an-analyzer-report/add-filters-to-an-analyzer-report). By default, totals only display the sum of the values which are visible on the report. If you want to see a total that includes the values that are filtered out, right-click on the **Grand Total** cell in the report and select **Display Totals that Include Filtered Out Values** from the menu.
* **Totals on top/left**

  Select to display totals at the top for column totals and on the left for row totals in a pivot table. Typically, totals appear at the bottom of columns and at the end of rows.

To hide grand totals while viewing a report as a pivot table, right-click the **Grand Total** cell on the report, and select **Hide Grand Total** from the menu. This method does not allow you to show grand totals again once it is hidden.