• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

Adding to Tables through a Pivot table

How do I add expense A in Table 1 + an expense with the same name in Table 2 within the pivot table?
Thanks,
JP
0
easycapital
Asked:
easycapital
1 Solution
 
dlmilleCommented:
You cannot do that.  You can, however, add a column in Pivot table source 1, which sums expense in both data sources, then update the pivot table with the expanded range, etc.

If you need assistance, I can elaborate further.

Dave
0
 
easycapitalAuthor Commented:
Good idea.
Thanks,
JP
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now