Multiple Sheet pivot table
Results 1 to 2 of 2

Thread: Multiple Sheet pivot table
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2014
    Location
    Dhaka, Bangladesh
    Posts
    116
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question Multiple Sheet pivot table

    Hi expert,
    I am using multiple sheet pivot table with
    Month Date Project Number Ledger Descriptions Received Payment
    Month Date Project Number Ledger Descriptions Received Payment
    January-2018 OV-2000 20-Fee 10,000
    January-2018 PR- 2001 22-Accommodation 1,000
    January-2018 PR- 2002 24-Advance 2,000
    January-2018 PR- 2002 24-Advance 3,000
    January-2018 PR- 2002 24-Advance 1,000 9,000

    but result is showing project and ledger "0" - how can get ledger and project info?

    Sum of Value
    Project Number Ledger Received Payment Grand Total
    (blank)
    January-2018 0 0 11000 15000 26000
    February-2018 0 0 22000 22000
    Grand Total 0 0 33000 15000 48000

  2. #2
    Board Regular
    Join Date
    Oct 2009
    Location
    Midlands, UK
    Posts
    7,552
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    3 Thread(s)

    Default Re: Multiple Sheet pivot table

    They would have to go in the rows area not the values area. They aren't numbers.
    Looking for opportunities

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •