Question

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

  • 25 July 2022
  • 2 replies
  • 18 views

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?


2 replies

Userlevel 7
Badge +1

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

Userlevel 1

Could be due to your primary key

Reply