For example, the total revenue in a given month is $1,000,000 When I pivot by a dimension like product categories (X, Y, Z), the revenue for each category will be:X = $400,000 Y = $150,000 Z = $400,000 Row total (looker) = $1,000,00 Row Total Manual Sum = $950,000What is a potential cause for this discrepancy?

Question

When pivoting by a dimension, the sum of values in the pivot categories do not match the row totals

For example, the total revenue in a given month is $1,000,000

When I pivot by a dimension like product categories (X, Y, Z), the revenue for each category will be:

What is a potential cause for this discrepancy?

Userlevel 2

Could be due to your primary key

Userlevel 7

+1

You’d have to show us your query/visualisation/data table, there could be many reasons