Incorrect tooltip values displayed in Pivot Table when hierarchy is collapsed

Q&A
,
1

image
image1145×414 44.8 KB

Hi ,

I’m facing an issue with QuickSight Pivot Table tooltips when using hierarchical rows.

Scenario 1 – Hierarchy Expanded (Works as Expected)

When the hierarchy is expanded (e.g., Country is visible), hovering over a cell displays the correct tooltip information.

For example:

  • Country: VN
  • Cum PF (A): 409K

This matches the value displayed in the pivot table.

Scenario 2 – Hierarchy Collapsed (Issue)

When the hierarchy is collapsed (i.e., the Country level is not expanded), the pivot table displays the aggregated value 939K, which is correct.

However, when I hover over the same cell, the tooltip shows:

  • Country: CN
  • Cum PF (A): 530K

This appears to be incorrect because:

  1. Since the Country field is not part of the visible hierarchy at this level, I would expect the Country value in the tooltip to be blank/null (or not displayed at all).

  2. The tooltip measure should display the aggregated value 939K, matching the value shown in the pivot table, instead of 530K, which corresponds to a single child row.

    Expected Behavior:

    When hovering over a collapsed hierarchy row:

    • The tooltip should either omit the Country field (or display it as null/blank).
    • The measure value in the tooltip should match the aggregated value displayed in the pivot table (939K).

    Has anyone encountered this behavior before? Is this the expected behavior of QuickSight tooltips, or is it a known limitation/bug?

    I’ve attached screenshots illustrating both scenarios.

2

Hi @Dharani_Sankar_S

Can you check what happens when you remove the Country field from the tooltip? I would assume that including that field may be making the tooltip use the first member’s values.

I am not sure you have any way to handle how to display the country name when the pivot is collapsed. I know you could do in tools like Power BI. I am not sure you have that mechanism here.

3

Hi @Giridhar.Prabhu Thanks for the suggestion. I removed the Country field from the tooltip, and now the aggregated value is displayed correctly. It appears that including Country causes QuickSight to evaluate the tooltip using the first underlying member when the hierarchy is collapsed.
Unfortunately, I still need to display the country when the hierarchy is expanded, so this seems like a limitation of the current tooltip behavior.