Home Forums Power Pivot Accounts Receivable data to show on one row

This topic contains 1 reply, has 1 voice, and was last updated by  TTtp1 2 weeks, 4 days ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #18019

    TTtp1
    Participant
    • Started: 1
    • Replies: 1
    • Total: 2

    Hi,

    I have a basic Accounts Receivable table with Rows including Invoice, Receipt and Credit Note and one Value Column. While one reference (Invoice) can have many lines due to sometimes multiple receipts and credit notes, I would like to tie all lines back to the original reference (Invoice) and show on one row with separate columns for Invoice, Receipt, Credit Note, Balance (Values)..

    I can show this in Power Pivot pretty easily, using a combination of Sumx filter or calculate distinct (I have tried many approaches and get a correct result).

    The trouble is when I show the result in Pivot table, the Values are not all on one row. Blank rows keep showing up which makes a “balance” calculation at the end impossible.

    I am sure it’s something simple I am not seeing.

    Any help please?

    Thanks,

    Tomas

     

     

     

     

     

    Attachments:
    You must be logged in to view attached files.
    #18021

    TTtp1
    Participant
    • Started: 1
    • Replies: 1
    • Total: 2

    attaching other screenshot

    Attachments:
    You must be logged in to view attached files.
Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.