I used pivot table to get the sum of revenue from the orders for each category. I am getting the sum as 1400. But when i duplicate this visual as a table, when I manually sum it , it comes around 1000. The filters are all same for both visuals. What could be the reason for diff b/w pivot table and table ?
If I am exporting the same data to excel, the revenuw comes around1000
The discrepancy in the sum of revenue between the pivot table and the duplicated table visual could be due to a few potential reasons:
Rounding Differences: QuickSight may be applying different rounding rules or precision settings for the pivot table and the table visual, leading to slight variations in the calculated sums.
Filtering Differences: Even though the filters appear to be the same, there might be some subtle differences in the way the filters are applied or interpreted between the two visuals. This could result in slightly different subsets of data being included in the calculations.
Aggregation Differences: The pivot table and the table visual may be using different aggregation methods (e.g., SUM vs. TOTAL) or handling null/missing values differently, which could impact the final sums.
Data Inconsistencies: There might be some inconsistencies or discrepancies in the underlying data, such as rounding errors, data entry issues, or other data quality problems, that could lead to the observed differences.
To investigate the issue further, you can try the following:
Verify the Data Source: Ensure that the data source is the same for both the pivot table and the table visual. Check if there are any differences in the data being used.
Inspect the Calculations: Carefully examine the calculations being used in the pivot table and the table visual. Verify that the same measures and dimensions are being used, and that the aggregation methods are consistent.
Check Rounding Settings: Look for any rounding settings or precision options that might be applied differently between the two visuals. Adjust the settings to see if that resolves the discrepancy.
Validate the Filters: Thoroughly check the filters applied to both visuals to ensure they are identical. Look for any subtle differences in the filter conditions or the way they are being interpreted.
Perform a Manual Calculation: Independently calculate the sum of revenue for the relevant categories and compare the result to the values displayed in the pivot table and the table visual.
Hi ,
It seems like when I am dragging the revenue in pivot table as sum, it adds up the duplicate values. How can I ensure ,the revenue only adds up for every unique order?
Hi @liya101,
It’s been awhile since last communication on this thread, were you able to find a work around for your case or are you still facing the same issue?
Is there a field that you can limit the duplicates being returned? If so, you could create a filter to only return the max (or min) value on those duplicates. That way, only one value is returned as opposed to the duplicates as well.
Let us know if you have any additional questions, otherwise, if we do not hear back in the next 3 business days, I’ll close out this topic.