+ Reply to Thread
Results 1 to 4 of 4

Amount not pulling through pivot table

  1. #1
    Registered User
    Join Date
    01-29-2015
    Location
    South Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    39

    Amount not pulling through pivot table

    Hi Guys

    Please can you assist with my attached file line 51 from my petty cash tab does not pull through on my pivot table tab.

    Please help on how to fix.

    Thanks Mellissa
    Attached Files Attached Files

  2. #2
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Amount not pulling through pivot table

    Your data source does not include row 51, hence the error. You need to change the data source of the pivot table. You can do so by selecting any cell on the pivot table >> go to analyze tab >> click change data source >> extend the range to include row 51.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    35,594

    Re: Amount not pulling through pivot table

    You have set the pivot table range to be

    PETTYCASH!$A$20:$Q$50

    so anything from row 51 onwards will be missed. Adjust it as required, or turn petty cash into a structured table.
    Glenn



  4. #4
    Registered User
    Join Date
    01-29-2015
    Location
    South Africa
    MS-Off Ver
    MS OFFICE 2010
    Posts
    39

    Re: Amount not pulling through pivot table

    Hi guys

    Thank you for all your help it has worked.

    Regards

+ 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. Sorting Pivot Table Pulling from Power Query Data Table
    By perkyparker in forum Office 365
    Replies: 1
    Last Post: 05-22-2021, 03:02 PM
  2. Pivot Table not pulling all of the data with one set-up but does in another
    By theunderdog47 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-14-2018, 11:05 PM
  3. Replies: 2
    Last Post: 09-13-2017, 01:55 AM
  4. Table amount instead off pivot table amount in the slicer
    By sportfan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-30-2015, 09:07 AM
  5. Replies: 1
    Last Post: 05-16-2014, 07:34 PM
  6. [SOLVED] Pulling out Top 10 from a Pivot Table.
    By davidx in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-30-2013, 08:06 AM
  7. Pivot table pulling wrong value
    By RestlessAde in forum Excel General
    Replies: 1
    Last Post: 11-25-2005, 02:35 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