Pivot table top 5 total-issue

manoranjan_d — Sat, 16 Nov 2024 04:25:59 GMT

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

topic Pivot table top 5 total-issue in App Development

Pivot table top 5 total-issue