I am using Max function in one of the calculated fields. The calculated field is used in a pivot table. When we sum the rows the calculated field does not sum correctly. For example the sum of calculated field should be 14,121 but it shows 10,000. Can you suggest how to resolve this issue
Hi @sikros
Welcome to the QuickSight Community!
Kindly share the details of your data and the calculated field and your pivot table visual details.
We can provide feedback once we have requisite amount of detail.
Regards,
Giri
My calculated field is as mentioned below
max(ifelse({biz_rnk} = 1, {planned_adv}, NULL))
I have added this field in a pivot table as shown in the attached pic.
If I sum the data at country level ideally ADV planned field should sum up to a value of 141,700
but in pivot table it is summing up to 10,000 which is not correct. Please see the attached second screen shot.
I am also attaching screenshot of actual sum that should be coming in. Please refer to 3rd screenshot
Hello Prabhu, I provided the details of my use case. Could you please look into them and share your inputs. Thanks
Hi @sikros
Since you have your measure doing a Max it is possible that the Sub Total is applying the Max as well at the sub-total level by default; see example below
But you can change the Totals property to use Sum instead and the results change accordingly.
I hope this is what is causing the problem. Can you try and let me know if that resolves your issue?
Regards,
Giri
1 Like
Hello Prabhu, the solution that you suggested worked. Thank you so much. Big help