Results 1 to 2 of 2

getpivotdata function with slicers

Threaded View

  1. 09-13-2020, 10:57 AM #1
    breathin
    breathin is offline
    Registered User
    Join Date
    09-08-2020
    Location
    TR
    MS-Off Ver
    Microsoft Office Professional Plus 2016
    Posts
    22

    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
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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. [SOLVED] GETPIVOTDATA function
    By bbddvv in forum Excel General
    Replies: 1
    Last Post: 06-27-2006, 10:25 PM
  7. [SOLVED] 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1