Hi all,
I have an issue in the top 6 total value in my pivot table
Dim 1) Region-> disabled the show total option
Dim 2) Micro region--> set to top 5 in the fixed number, avoided total and other values
Exp 1) count (ID)
Exp 2) count (head count)
Now the issue is when it is collapse or expanded the pivot shows the over all total for the that region . the actual value should be top 5 of the micro region for that region.
example the over all total for the top 5 micro region in APAC is 50 but it shows the over all total as 200 for the apac region.
I tried rank aggr,top, function nothing helped much with correct value