+ Reply to Thread
Results 1 to 3 of 3

To highlight source data values for a value selected in pivot table

  1. #1
    Registered User
    Join Date
    09-01-2018
    Location
    India
    MS-Off Ver
    2010
    Posts
    5

    To highlight source data values for a value selected in pivot table

    I am no able to find out how to highlight the source data values for a value selected in my pivot table. e.g. if I select a value (say 57111.25) in my pivot table then all the values/rows in the source data whose sum is that value (57111.25) should get highlighted/colored/numbered. There is a functionality through which that data is extracted in another sheet but I want it to get highlighted in the original source data itself.

    Any help would be much appreciated either through some function or VBA. Thanks in advance.

  2. #2
    Registered User
    Join Date
    11-01-2014
    Location
    Chico, CA, USA
    MS-Off Ver
    2007, 2010, 2013, 2016
    Posts
    2

    Re: To highlight source data values for a value selected in pivot table

    A standard feature of pivot tables is "Show Details".
    If a pivot table has PivotTable options | Data | "Enable Show Details" on then:
    double click
    or
    right click | Show Details
    to copy the data behind that cell into a new detail (or drilldown) worksheet.

    Granted, this is not what you asked for, but would it suffice?

    There are VBA solutions that show what could be done;
    See: Pivot Table - DrillDown at
    190025-pivot-table-drilldown.html
    (Sorry about the link format, I do not have the reputation to post links.)
    Last edited by Grumpy Old DBA; 06-21-2019 at 01:02 PM.

  3. #3
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: To highlight source data values for a value selected in pivot table

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)

+ 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. [SOLVED] My pivot table is not showing the same values as the source data
    By heytherejem in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-26-2018, 08:25 AM
  2. [SOLVED] Pivot table - Unable to navigate to source data from pivot table
    By Richavlaues in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-30-2016, 10:37 AM
  3. Replies: 0
    Last Post: 01-06-2016, 07:00 AM
  4. [SOLVED] Pivot table is doubling values from Source data
    By Crysizzle in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-03-2013, 10:22 AM
  5. Replies: 1
    Last Post: 03-06-2012, 02:02 PM
  6. Replies: 1
    Last Post: 06-22-2010, 09:10 AM
  7. Replies: 1
    Last Post: 06-20-2010, 04:00 AM

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