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 Lee 3 months 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.