• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • 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

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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