+ Reply to Thread
Results 1 to 2 of 2

GETPIVOTDATA with a NOT function?

  1. 03-24-2009, 07:07 AM #1
    zonino
    zonino is offline
    Registered User
    Join Date
    08-04-2007
    Location
    London
    MS-Off Ver
    work: 2003, home: 2008 for Mac
    Posts
    32

    GETPIVOTDATA with a NOT function?

    Hi All,

    I've got a pivot table that takes data with a number of document "types". I want to sum everything for december apart from document type "XX". can I do this within the GETPIVOTDATA() function?

    currently I have


    =GETPIVOTDATA("Value COCurr",$A$3,"Month",200809,"DocTyp","")
    the bit in bold is the section that (I assume) needs modifying.

    thanks in advance!
    Reply With QuoteRegister To Reply
  2. 03-24-2009, 07:21 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,431

    Re: GETPIVOTDATA with a NOT function?

    I think you would need to calculate the value using 2 formula.
    first would return the value for all DocTypes in December the other would return value for specific DocType in December.
    You then subtract one from the other.


    =GETPIVOTDATA("Value COCurr",$A$3,"Month",200809) - GETPIVOTDATA("Value COCurr",$A$3,"Month",200809,"DocTyp","XX")
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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