• Learn
    • Courses
    • Career Tracks
    • Projects
    • Upcoming Courses
  • Certificates
    • Career Track Certificate
    • Course Certificate
  • Resources
    • All Resources
    • Course Notes
    • Templates
    • Infographics
    • Career Guides
    • Practice Exams
    • Blog
    • Success Stories
    • Calculators
  • Pricing
  • For Business
    • Team Plan
    • Live Training
  • Login
  • Sign Up
Log In Sign Up
Follow this topic
Share
Oyindamola Oluwapelumi Okesola
Posted on:

20 Nov 2022

3

NOT GETTING THE GETPIVOTDATA OPTION

in Data Analysis with Excel Pivot Tables / GetPivotData is great! Extracting data from the Master Pivot Table

Good day!

When practicing, I am not getting the getpivotdata option, Please see below what i am getting when I enter the equals sign and link the cell to a cell from the pivot table. Instead of getting the GETPIVOTDATA function, it shows "PIVOT TABLE!"

Thanks.

image.png

0 answers ( 0 marked as helpful)

Submit an answer

related questions

Roman Collins
0
16
Getpivotdata- filling a blank sheet
Longyin Li
2
16
The 'GetPivotData' formula does not work
Khalid Alshmmari
0
14
Can not find New Slicer Style on Excel(Mac)
Abdelrahman Essam
0
8
Getting different (GETPIVOTDATA) Formula
Muhammad Ali Jafri
0
6
Don't understand why am i getting error in some cells while others are responding fine.
Panagiotis Blatsas
0
6
Can you please explain how to fill the table GETPIVOTDATA in practice exam 2?
Abrar Muhtasim
0
6
Resolved: Not finding "option" after selecting slicer
Snoor Salihi
1
4
Practice Exam can not be access with desktop

All the Data Science Courses You Need

About

  • About Us
  • Instructors
  • Contact Us
  • Pricing

Learn

  • Courses
  • Career tracks
  • Career Certificate
  • Course Certificate

Resources

  • Course Notes
  • Templates
  • Career Guides
  • Practice exams
  • Calculators
  • Blog

Platform

  • Success stories
  • Q&A Hub
  • Help Center
  • Verify Certificate
© 2023 365 Data Science. All Rights Reserved.
Sitemap Terms of Use Privacy Policy Cookies