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?