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?
You’d have to show us your query/visualisation/data table, there could be many reasons
Could be due to your primary key