+ Reply to Thread
Results 1 to 2 of 2

getpivotdata function with slicers

  1. #1
    Registered User
    Join Date
    09-08-2020
    Location
    TR
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    6

    getpivotdata function with slicers

    Hi all,

    I need help about attached file. I use getpivotdata formula. I want this formula to show the value of the latest month(which is haziran in the pivot) if nothing is chosen from the slicer. Currently, it shows the field of "general total" if nothing is chosen from slicers.
    Can you please help?
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-30-2019
    Location
    Bistrita, Romania
    MS-Off Ver
    2013; 365
    Posts
    221

    Re: getpivotdata function with slicers

    I wouldn't try it with getpivotdata, I don't like that formula for some reason.

    If you want to extract the value from the pivot table, you could use:
    =INDEX(Sayfa2!$C$4:$C$16;MATCH(TEXT(MAX($B$2:$B$27);"mmm");Sayfa2!$A$4:$A$16;0))

    It looks in the source data to find the max date and extracts the "mmm" from it, then looks for that mmm in the pivot sheet and extracts the corresponding value.

    You could also work with a formula on the source data of the pivot to make an average of the values from latest month.
    To show your appreciation
    Click ★ Add reputation!

+ 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 function
    By marshak in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-18-2018, 05:04 PM
  2. Getpivotdata and slicers
    By Blake 7 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-26-2016, 05:04 PM
  3. [SOLVED] Disconnect Slicers, Change Pivot Table Source, Reconnect Slicers: a problem
    By Geoff. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-30-2015, 02:27 PM
  4. Using IF function together with GETPIVOTDATA
    By Kagesen in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-20-2011, 05:06 AM
  5. Function within GETPIVOTDATA
    By trendkill in forum Excel General
    Replies: 0
    Last Post: 03-25-2011, 11:53 AM
  6. GETPIVOTDATA function
    By bbddvv in forum Excel General
    Replies: 1
    Last Post: 06-27-2006, 10:25 PM
  7. GETPIVOTDATA function
    By Maureno in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-08-2005, 05:00 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