+ Reply to Thread
Results 1 to 2 of 2

Pivot Filter Top 10 using total stacked value

  1. #1
    Registered User
    Join Date
    02-05-2020
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1

    Question Pivot Filter Top 10 using total stacked value

    Hi

    I have tried searching for an answer to this but unable to find anything for what seems to me a simple task.

    I have a pivot table.

    I have a stacked pivot chart attached to it.

    I want to filter/display the Top X# items on the chart.

    I want to do this filter on the TOTAL sum of the values that are stacked together, not an individual value within the stack.

    I can add a total value too in order to do the filter, but that ruins my stacked chart visually as it becomes essentially 100% larger.

    I can manually delete the series, but it reappears, even when copy and pasting elsewhere.

    I feel dumb having to ask but I hope someone can aid me here.

    Thanks in advance

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,965

    Re: Pivot Filter Top 10 using total stacked value

    Administrative Note:

    Hi and welcome
    although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
    So, please update your profile to something more precise then "Home" ( country will suffice, no need to be more precise).
    Thank you for helping us to help you

+ 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. Stacked columns - showing % out of total
    By Rebelexcel in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 08-04-2019, 12:23 PM
  2. [SOLVED] Filter Pivot Table with a fixed value called "TOTAL" in Pivot Field Name
    By trizzo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-06-2015, 12:57 PM
  3. Replies: 3
    Last Post: 07-30-2014, 07:09 PM
  4. [SOLVED] Pivot Table Filter - Without changing Grand Total
    By Nuno W in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-21-2014, 06:00 AM
  5. Stacked charts and adding % of total
    By matthewm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-22-2013, 08:56 AM
  6. Pivot Table - Sub Total & Grand Total Filter
    By ramki in forum Excel General
    Replies: 1
    Last Post: 08-07-2009, 11:40 PM
  7. [SOLVED] total value of stacked charts
    By OkieViking in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-28-2005, 09:06 AM

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