Power Pivot summarise transactions

I have a table of entities (companies) that transact with each other. I have a table of transactions between these entities. I would like to create a pivot table in Excel 2013 that summarizes the cash flow of the transactions for each entity and for each date.

The project xlsx file is attached. The sheets are the following:

Output required: what the result should look like

Attempt_1: what I tried with a measure

Attempt_2: what I tried with a calculated field

Entities: the source table of entities

Transactions_1: the transactions table (used for borrower)

Transactions_2: an exact copy of the transactions table to provide the (used for lender)

Please use only Excel, Power Pivot and DAX, no VB. The simpler the solution the better.

To be clear, the result needed is simply the "cash flow", which is the sum of positive [amount] if you are a lender and the negative [amount] if you are a borrower for any transaction

Habilidades: Excel

Veja mais: power pivot, pivot table excel, excel PIVOT, excel pivot table, excel dax, dax, copy result excel, power flow file, cash flow excel, pivot table project, excel cash flow, pivot table xlsx, power hour source code, pivot xlsx, android power hour source code, vbscript change excel pivot table data source, vb net pivot table data source sql server database, vb copy table table, table copy vb, create excel pivot table, pivot vba data source, usb power reset source, create pivot excel, list pivot table data source, copy date field excel

Acerca do Empregador:
( 1 comentário ) Luxembourg, Luxembourg

ID do Projeto: #6838285

6 freelancers estão ofertando em média $34 para esse trabalho


Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your refere Mais

$50 USD in 0 dias
(232 Comentários)

Award to solve as written in project details. Thanks, Tom

$56 USD em 1 dia
(17 Comentários)

hi, Dear employer. i am interesting in ur project. i have attached file with excel-macro. i also know vb. i think i am appropriate for ur task. if u hair me, i'll do my best to carry out successfully. i would like to Mais

$15 USD em 1 dia
(0 Comentários)

A proposal has not yet been provided

$40 USD em 1 dia
(0 Comentários)

Rates are negotiable but the most priority us feedback and ratings. i can deliver this within a day. Please contact me.

$20 USD em 1 dia
(0 Comentários)

I am a [url removed, login to view] graguate also a Data Entry/Data Processing Expert . I also have experience in word and excel. PDF to Word and Excel. I know the value of time. I am very hard working . My motive is to make my emp Mais

$20 USD em 1 dia
(0 Comentários)