How do I make a cashflow with pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi everyone. I'm finalizing a cashflow with pivot table but I cannot find a
way to interact the 2 pivots (payments and receivings). I'd like that it
gives me the results daily. All my friends tell me it's not possible, or
easy... but it's a logical thought and there must be a way to do it.

I'd apreciate your help.

Thanks
 
Hi

If you had your Receipts and Expenses in the same table, with expenses being
negative, then it would be easy.
If you are generating 2 pivot tables form 2 separate source tables then I
think you would need to use the GetPIvotData function to extract the
relevant data from each pivot table to another sheet for your cashflow.

Take a look at Debra Dalgleish's site for help on the GetPivotData function.
http://www.contextures.com/xlPivot06.html

If you have difficulties, post back.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table with Data Model Connection - getpivotdata reference issue 0
Export Pivot table 1
Problem with pivot tables 1
Pivot table data source 1
Pivot Table Source 3
Link Drop Down with Pivot Table 2
N/A in pivot table become 0 1
How can I use a pivot table as source for a second table? 2

Back
Top