# Data Studio: Grand Total Over a Date Range is Less Than Sum of Individual Rows Broken Out By Date

This page will assist you with the following issue:

When reporting individual values by date in Data Studio, the sum of these individual values over a date range may be less than the grand total of the values over the same date range.

For example, this Google Analytics 4 (GA4) report of Total Users by Date over June 1 - 2, 2024 shows values of 331 and 290, summing to *621* Total Users.

![](https://knowledge.powermyanalytics.com/application/reports/images/data-studio-grand-total-over-a-date-range-is-less-than-sum-of-individual-rows-broken-out-by-date-1.png)

However, the grand total shown is only *609*.

![](https://knowledge.powermyanalytics.com/application/reports/images/data-studio-grand-total-over-a-date-range-is-less-than-sum-of-individual-rows-broken-out-by-date-2.png)

Similarly, using a date control that spans June 1 - 2, 2024 while reporting Total Users without any dimensions will produce a value of 609.

![](https://knowledge.powermyanalytics.com/application/reports/images/data-studio-grand-total-over-a-date-range-is-less-than-sum-of-individual-rows-broken-out-by-date-3.png)

## Cause

Both the daily values and the grand total are correct. The grand total is a *unique* count over the date range.

- In this example, because the summed rows showed 621 total users and the grand total showed only 609 over the date range, this is a difference of 12 users. This means 12 users were present on both June 1 and June 2, 2024.
- A sum of total users by day (equalling 621) would result in these users being counted twice, once for each day, while the grand total is the de-duplicated value (609).

The following is a partial list of fields whose daily values will not sum up to the grand total over a multi-day range. The sum of the daily row values for these fields will exceed the grand total:

| Data source | Affected fields |
| --- | --- |
| Facebook Ads | Reach, Frequency |
| Google Analytics 4 | All fields containing "User" (Active Users, Active1day Users, Active7day Users, Active28day Users, Total Users) except for New Users |
| LinkedIn Ads | Reach, Average Frequency |
| Pinterest Ads | Reach, Frequency |
| Snapchat Ads | Earned Reach, Paid Reach, Total Reach, Frequency |
| TikTok Ads | Reach |
