Results 1 to 3 of 3

Thread: How to Active Drill Up and Drill Down Option in pivot Table Analyze Tab

  1. 05-26-2015, 08:08 PM #1
    chethankumar700
    chethankumar700 is offline
    Junior Member
    Join Date
    Mar 2015
    Posts
    1
    Rep Power
    0

    How to Active Drill Up and Drill Down Option in pivot Table Analyze Tab

    Hi,

    I am using MS office 2013. While using Pivot table, Analyze and Design Tabs will appear, In that Analyze Tab Drill up and Drill option always Non-active, I can't able to use......

    How to make that options Non active to Active ((Non-usable to Usable))????
    Attached Images Attached Images
    Reply With Quote Reply With Quote
  2. 05-28-2015, 07:22 AM #2
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    13
    Could you please attach your file for better clarity.
    Reply With Quote Reply With Quote
  3. 05-28-2015, 07:30 AM #3
    LalitPandey87
    LalitPandey87 is offline
    Senior Member LalitPandey87's Avatar
    Join Date
    Sep 2011
    Posts
    222
    Rep Power
    13
    You can take help from
    https://support.office.com/en-us/art...7-629bf6f7ee0b
    Excel Pivot Table DrillDown
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Use SUMIFS on pivot table data
    By malta1 in forum Excel Help
    Replies: 1
    Last Post: 02-18-2014, 10:55 AM
  2. Preparing Trial Balance Using Pivot Table
    By Zaigham in forum Excel Help
    Replies: 4
    Last Post: 05-14-2013, 11:57 AM
  3. Create a Pivot table
    By NITIN SHETTY in forum Excel Help
    Replies: 3
    Last Post: 01-26-2013, 11:01 AM
  4. Lookup and Count Using Pivot Table
    By RobExcel in forum Excel Help
    Replies: 2
    Last Post: 12-21-2012, 11:08 AM
  5. Filter more than one pivot table at one time
    By larryt1940 in forum Excel Help
    Replies: 8
    Last Post: 05-04-2012, 06:45 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
  •  

Forum Rules