• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter a Pivot Table on % Running Total in Column

betsig250

betsig250

New Member
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?
 
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.
 
You must log in or register to reply here.
Back
Top