+ Reply to Thread
Results 1 to 2 of 2

Get top 5 data from a column in pivot table to another sheet

  1. 09-13-2021, 02:05 PM #1
    nilesh.acharya
    nilesh.acharya is offline
    Registered User
    Join Date
    07-20-2021
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    8

    Get top 5 data from a column in pivot table to another sheet

    Hi, Is there a way that I can get top 5 data from a column in pivot table to another sheet.
    Reply With QuoteRegister To Reply
  2. 09-13-2021, 11:38 PM #2
    alansidman
    alansidman is offline
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,865

    Re: Get top 5 data from a column in pivot table to another sheet

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add custom column to Pivot Table or update Source data FROM pivot table
    By jschneiter2 in forum Excel Charting & Pivots
    Replies: 15
    Last Post: 08-20-2020, 03:04 PM
  2. [SOLVED] VBA: Pull data based on time frame from Raw data or pivot table to dashboard sheet column
    By Sharonjit in forum Excel Programming / VBA / Macros
    Replies: 55
    Last Post: 12-20-2018, 10:00 AM
  3. Copy only the data from one pivot table field and paste it into a column on another sheet
    By rcdavis28 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-28-2018, 05:39 PM
  4. Table to column problem to create dataset for pivot table [Bloomberg data to pivot table]
    By fajfus in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  5. [SOLVED] Have macro looking at column in summary sheet and matching to data in pivot table
    By sbrandhorst in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2016, 05:30 PM
  6. Need to pull pivot table column on new sheet based on a data field (like date) - how?
    By tripmaster in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-18-2015, 07:23 PM
  7. PProtect a sheet containing a pivot table but allow table to refresh data?
    By ThomasCarter in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-22-2013, 05:46 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1