+ Reply to Thread
Results 1 to 5 of 5

GETPIVOTDATA() when column has not title

Hybrid View

  1. #1
    Registered User
    Join Date
    12-05-2011
    Location
    UK
    MS-Off Ver
    Excel 365
    Posts
    57

    Re: GETPIVOTDATA() when column has not title

    This is a Pivot Table produced from PowerPivot. The totals I want to get hold of are all derived using CALCULATE(), and are 'Values' in the Pivot Table. I don't know why it does not have a column heading, and I cannot see how to add one.

    I can't attach the spreadsheet, because it is dependent on data that is on a database,so it would not work. The following though is a screen shot;

    Capture.PNG
    Last edited by Nerdio; 06-26-2015 at 10:11 AM.

+ 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] GETPIVOTDATA – How to force getpivotdata to accept missing data
    By scottc_00 in forum Excel Formulas & Functions
    Replies: 39
    Last Post: 02-11-2015, 03:23 PM
  2. Return the Title of a column if the column is the highest column with data
    By williamspage in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-22-2013, 10:05 AM
  3. Replies: 4
    Last Post: 10-19-2012, 12:09 PM
  4. Replies: 2
    Last Post: 07-21-2006, 05:10 AM
  5. [SOLVED] GetPivotData with column grand totals
    By Enrico Campidoglio in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-14-2005, 10:05 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