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}]))
/
sum(
(sum({nb_test_number},[{service_request_id}])
/
sum({nb_duplicate},[{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 ?
Thanks,