Pivot Table missing combinations

Q&A
, , ,
1

Hello,

I have a pivot table with no filters, year in columns and several fields in rows (9). This is the output I get when I display it:

image
image1596×247 26.6 KB

2 problems there:

  • Totals do not match: it looks like some values that should appear in rows are hidden, what’s happening?
  • Max year displayed is 2030 but I know in data the greatest year is 2057, when I do filter on brands (field in rows) that correspond to 2057 data are displayed correctly, but by default I do not see them. Why? (see screenshot below)

image
image286×219 5.87 KB

image
image720×212 3.91 KB

Thanks in advance!

2

Hey @Francesca ,

your first problem seems to be that the columns are not rendering correctly. Unfortunately, I’m not sure how to properly load the data initially, as I still encounter the same problem whenever I refresh the site.

Aufzeichnung-2025-08-26-095737

For your second point, there are limitations within the pivot table in: Using pivot tables - Amazon Quick Sight. Without filtering, you might be using more records than the pivot table can display.

BR

Robert

1 Like
3

Hi @Francesca,

Following up here as it’s been awhile since we last heard from you on this thread; did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @Francesca,

Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you