Yandex Cloud
Search
Contact UsTry it for free
  • Customer Stories
  • Documentation
  • Blog
  • All Services
  • System Status
    • Featured
    • Infrastructure & Network
    • Data Platform
    • AI for business
    • Security
    • DevOps tools
    • Serverless
    • Monitoring & Resources
  • All Solutions
    • By industry
    • By use case
    • Economics and Pricing
    • Security
    • Technical Support
    • Start testing with double trial credits
    • Cloud credits to scale your IT product
    • Gateway to Russia
    • Cloud for Startups
    • Center for Technologies and Society
    • Yandex Cloud Partner program
    • Price calculator
    • Pricing plans
  • Customer Stories
  • Documentation
  • Blog
© 2025 Direct Cursus Technology L.L.C.
All solutions
    • All solutions for DataLens
    • How to access Yandex Direct from DataLens
    • How to get a token to access a Bitrix24 database from DataLens
    • How to connect to the MoySklad connector
    • How to restore a broken dataset
    • How to recover deleted objects
    • How to find IP addresses used for connecting to external data sources
    • How to filter previously filtered data using a selector
    • Resolving the `ERR.DS_API.FIELD.TITLE.CONFLICT` error
    • Resolving the `ERR.DS_API.REQUEST_TIMEOUT` error
    • Resolving the `ERR.DS_API.SOURCE_CONFIG.TABLE_NOT_CONFIGURED` error
    • Troubleshooting issues while accessing a Google Sheets spreadsheet from DataLens
    • `Total` values in DataLens table charts mismatch the respective data from Yandex Metrica
    • Resolving the `ERR.DS_API.US Not correct folder_id` error
    • Resolving issues with joined tables when connecting to Bitrix24
    • Resolving the `ERR.DS_API.FORMULA.TRANSLATION.DATA_TYPE` error
    • Resolving issues with access to the podcast statistics dashboard in Yandex Music
    • Resolving the `ERR.DS_API.FORMULA.VALIDATION.AGG.INCONSISTENT` error
    • Fixing issues when loading a CSV file into a dataset as a data source
    • Resolving the `Validation error Request failed with status code 500` error when saving a dashboard in DataLens
    • Resolving the `Bad Request for url MetrikaHttpApiException direct_client_logins` error
    • Resolving the `ERR.DS_API.FORMULA.VALIDATION.AGG.INCONSISTENT - Inconsistent aggregation among operands` error
    • Resolving the `ERR.DS_API.US.BAD_REQUEST data.key should not start with /` error
    • Some fields are not displayed in datasets built on Yandex Metrica
    • Resolving the `SSL is required` error
    • Resolving an incorrect `Total` value in a pivot table

In this article:

  • Issue description
  • Solution
  • If the issue persists
  1. DataLens
  2. Resolving an incorrect `Total` value in a pivot table

Resolving an incorrect Total value in a pivot table

Written by
Yandex Cloud
Updated at December 17, 2025
  • Issue description
  • Solution
  • If the issue persists

Issue descriptionIssue description

Once added to the pivot table, the Total field values are displayed incorrectly.

SolutionSolution

In pivot tables, row values are calculated using the same formulas as the measure aggregation. However, the totals row does not display results calculated with LOD expressions, window functions, and time series functions.

For more details, see this guide.

If the issue persistsIf the issue persists

If the above actions did not help, create a support ticket. When creating it, please attach a screenshot showing the incorrect values.

Was the article helpful?

Previous
Resolving the `SSL is required` error
Next
All solutions for Yandex Data Processing
© 2025 Direct Cursus Technology L.L.C.