Filter a Pivot Table on % Running Total in Column

[betsig250]

Hello..

I have a pivot table where I have a running total column and also a % running total in column. I want to filter my records to only show when % Running Total is between 0% and 10%. Is that possible?

 

[r1c1]

IF what you want is to show only top 10% of values after arranging in descending order, then

Follow below steps:

1. Once the running total field is added to pivot, go to the row label, click on filter button
2. Choose value filter > top 10
3. Specify Top 10 percent of sum of values as criteria
4. Click ok and done.

Please note that this will show running total percentages in-correctly in the report as running total is calculated based on the displayed values only.

On the other hand, if you want to filter and show only top 10% values based on the displayed order of the report (say on date or ID instead of descending order of values), then I am not sure if this is possible with regular pivot tables. You may be able to do this with Power Pivot though.

 

[betsig250]

Thanks I can make this work!