+ Reply to Thread
Results 1 to 3 of 3

Adding manual columns next to pivot tables and pulling pivot table data for formulas

  1. #1
    Registered User
    Join Date
    09-12-2017
    Location
    San Diego
    MS-Off Ver
    2010
    Posts
    1

    Adding manual columns next to pivot tables and pulling pivot table data for formulas

    I'm trying to add in manual columns next to my pivot table and then use the pivot table columns for manual formulas however the pivot table columns are long strings it won't let me change them to standard numbers. Does anyone know how to do this? It's an olap pivot table.
    Attached Images Attached Images

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    San Escobar but I could be anywhere in the world
    MS-Off Ver
    power BI
    Posts
    9,042

    Re: Adding manual columns next to pivot tables and pulling pivot table data for formulas

    Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc. Additionally, due to how some browsers behave, many of our members cannot see uploaded pictures/images. Please do not take this route.
    Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.
    Include in the attachment any code you're currently using (whether it works or not) and an After of what you wish the output to be.

    To attach a Excel file to your post,
    • click Go Advanced,
    • scroll down until you see Manage Attachments,
    • click that and select Browse,
    • select your file and click Open,
    • click Upload and you will see your attachment below Upload Files from a website
    • click Close this window,
    • click Submit reply

    After that you should see attachment in your post

  3. #3
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Adding manual columns next to pivot tables and pulling pivot table data for formulas

    Hi

    You can either turn off the option to use GETPIVOTDATA formulas in Excel Options (formulas section) or just type a direct cell reference like =F2.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Replies: 7
    Last Post: 02-27-2017, 07:41 AM
  2. Pivot Tables: Adding a Table with percentage
    By Volle12 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 02-25-2015, 11:47 PM
  3. Pivot charts/pivot tables - pulling in visibly the search filter
    By clairh2011 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-08-2013, 09:07 AM
  4. Complex Request with Pivot Tables and copying pivot data to new page with formulas
    By Obsessed in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2013, 09:16 AM
  5. Replies: 3
    Last Post: 02-27-2012, 08:03 PM
  6. Macro Pivot Table vs Manual Pivot Table - different results
    By vodka in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-03-2008, 04:43 PM
  7. Change Variable data on 1 pivot table, make same changes in other pivot tables
    By matt4003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2008, 10:55 PM

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