+ Reply to Thread
Results 1 to 1 of 1

Auto sort and hide rows in pivot table

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    Philippines
    MS-Off Ver
    Ms Office 2007
    Posts
    10

    Auto sort and hide rows in pivot table

    Hello,

    New question. I have this pivot table (see attachment). The procedure will be I will select values from the slicers then pivot table will be automatically updated.
    Problem is, the % share at the last column is not always sorted (highest to lowest). I want it to be automatically sorted. I also want to show parts that are within 80% share. Example, 1st line is 60, 2nd line is 20, 3rd line is 10, etc. I only want to display the 1st and 2nd line because their total share is 80%.
    Is there a way to automatically do this?
    Thank you. More power!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto Sort Pivot Table
    By kristanmarie in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 12-28-2016, 02:38 PM
  2. [SOLVED] Macro to hide rows in pivot table if values in row C&D are both 0
    By nhouse20 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-18-2012, 10:09 AM
  3. Pivot Table total rows hide?
    By EnergyEngineer in forum Excel General
    Replies: 3
    Last Post: 04-29-2008, 02:56 PM
  4. [SOLVED] How do I hide rows in a pivot table with zero values?
    By fs in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-22-2006, 04:15 PM
  5. Pivot Table - How to hide all rows which is 0
    By Ctech in forum Excel General
    Replies: 2
    Last Post: 05-03-2006, 08:56 AM
  6. [SOLVED] How do i hide rows in pivot table that has zero values?
    By SHIAN in forum Excel General
    Replies: 0
    Last Post: 11-02-2005, 06:20 PM
  7. Replies: 0
    Last Post: 11-02-2005, 06:17 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1