Pivot table shows "Can't load all the data" when enable "Row Total"

Q&A
, , ,
1

I create a Pivot Table and it works fine until I tried to enable the “Row Total”. The “Total” row will keep loading and an error message will pop up showing “Can’t load all the data”. How can I get the “Total” showing on my Pivot Table?

2

Hello Joshua,

First of all Welcome to the Quick Sight Community.!
Is your table too big ? how many Rows & Columns are we talking here ?
if the issue is with only Row Total I would suggest to raise a AWS support ticket and report the issue. This will help AWS team to gather and identify the exact cause of the issue.
To raise the ticket, please follow the below link -Creating support cases and case management - AWS Support

Hope this helps.
Cheers,
Deep

3

Hi Deep, thank you for prompt reply! Yeah the issue is only with the Row Total and the rest of Pivot Table are showing fine. I read somewhere that Pivot Table can only accept less than 500K rows, but my table is only ~370K rows after applied to a filter. I will create a case accordingly then. Thanks!