+ Reply to Thread
Results 1 to 4 of 4

How to drag from pivot table

  1. #1
    Registered User
    Join Date
    06-18-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    16

    How to drag from pivot table

    Hello, I have a problem dragging from the pivot table

    basically, I want to get quantity*price (Yellow area in my file). I get the price from another sheet and quantity from pivot table but when i try to drag data, it doesnot work. The problem is the data from pivot table(quantity) does not go as I expect. what should I do?
    I attached my file in this post
    Thank you very much
    Attached Files Attached Files

  2. #2
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    259

    Re: How to drag from pivot table

    Instead of clicking into your pivot when you select the value you want to multiply, try typing the exact cell reference, i.e.: A4*F4
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-18-2017
    Location
    London, England
    MS-Off Ver
    2013
    Posts
    16

    Re: How to drag from pivot table

    Thank you very much. It's so easy but I did not expect that at all.

  4. #4
    Forum Contributor Mvaldesi's Avatar
    Join Date
    01-21-2011
    Location
    Plano, TX
    MS-Off Ver
    MS365 (PC) v.2108
    Posts
    259

    Re: How to drag from pivot table

    No worries; glad to help. Please make sure you mark the thread as SOLVED if you've got what you need. Cheers!

+ 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. Default cannot drag fields to pivot table
    By jalea148 in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-30-2017, 07:59 PM
  2. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  3. [SOLVED] How to drag and drop multiple filters at once in a pivot table?
    By Mirisage in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 09-09-2014, 05:37 AM
  4. Drag and copy based on pivot table cell
    By m.yarahmadi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-30-2014, 02:18 AM
  5. [SOLVED] Anyone have a Macro that Automates Drag fields in a Pivot table
    By Rec1ne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 11:39 AM
  6. Drag formula based on pivot table cell
    By Suep in forum Excel General
    Replies: 0
    Last Post: 06-14-2006, 11:15 PM
  7. I cannot drag a Pivot Table field into the page area
    By KimboR in forum Excel General
    Replies: 2
    Last Post: 02-23-2005, 11: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