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:

  • X = $400,000
  • Y = $150,000
  • Z = $400,000
  • Row total (looker) = $1,000,00
  • Row Total Manual Sum = $950,000

What is a potential cause for this discrepancy?

0 2 81
2 REPLIES 2

Dawid
Participant V

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

n_davis
Participant V

Could be due to your primary key

Top Labels in this Space
Top Solution Authors