Pivot Table issue

I created a Pivot table with one measure and 4 dimensions.

Values are correctly displayed as all level of the pivot (collapsed or expended).

When I add a 5th dimension (or more), I cannot see the values of the measures when the lines are collapsed. I can only see the value when the lines are fully expended to the last dimension.

Here is the measure I have :
sum(distinct_count({service_request_id_Complaints}, [{service_request_id}]))

In my dataset, I have one nb_test_number per service_request_id, but the lines of service_request_id are replicated, the nb_duplicate gives me the number of time the lines are replicated.

With 4 dimensions :

With 5 dimensions (collapsed - at any level, the value is not shown, only for total line)

With 5 dimensions (fully expanded)

Do you know what causes the issue ?


Thank you for letting us know. I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!