+ Reply to Thread
Results 1 to 2 of 2

Pivot table functions beside GetPivotData()

  1. #1
    Forum Contributor
    Join Date
    04-09-2013
    Location
    City, World
    MS-Off Ver
    Office 365
    Posts
    248

    Pivot table functions beside GetPivotData()

    Hi
    I tried to google this but I got only pivot table tutorials etc. I wonder if there is a list of pivot table functions in excel or we only have GetPivotData()? Thak you very much.

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Pivot table functions beside GetPivotData()

    Hi,
    GetPivotData() is used to extract data from a Pivot Table to a cell in worksheet. That is not a Pivot table function is an Excel build-in function . For more information about "Pivot Table function" you need to search DAX(Data Analysis Expressions) that is used in Power Pivot data model.
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

+ 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] Unable to get data from Pivot Table via GETPIVOTDATA
    By PB4InfoCentral in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-14-2020, 12:16 PM
  2. =GETPIVOTDATA & Expanding Pivot Table
    By Jimbo123456 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-09-2019, 06:15 AM
  3. [SOLVED] GETPIVOTDATA or Formula to get the Data from Pivot Table
    By toci in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-25-2016, 10:04 PM
  4. Replies: 3
    Last Post: 05-21-2014, 09:45 AM
  5. Easy way to reference a Pivot Table without using GETPIVOTDATA
    By davidx in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-30-2013, 10:33 AM
  6. Pivot Table help - Getpivotdata
    By pdawg123 in forum Excel General
    Replies: 1
    Last Post: 03-21-2012, 09:47 AM
  7. GETPIVOTDATA-on a pivot table
    By Hennie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-06-2006, 06:50 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