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.

--
Regards
Roger Govier



"Luana - Brazil" <Luana - wrote in message
...
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