Can pivot tables work together to calculated results of data? If so, which lesson teaches this information?
I have a pivot table summing commission earned each month and another summing commission paid for each month. I want to know the difference for between the commission earned and commission paid for each month, each time both pivot tables update.
Hi Damon. Not sure what you're asking for. I'd need to see some screen shots of what you're trying to do.
Damon LeeOP
@Reply 4 years ago
I was able to use a calculated field to display the information I needed. For now, I'll plow through the expert courses so I can get too the advance level and lear more how pivot tables can perform calculations.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.
