Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
684
Views
Topic starter
Hello all, i am having trouble figuring out how to compare two separate columns against each other. For instance if i drop two fields into a row or column within the pivot table field section it keep populating the same amount/value for each column even though there is definitely different amounts.
Posted : 06/10/2020 10:25 pm
Hi Joseph,
Welcome to our forum! This post explains how to add a calculated field to a PivotTable.
If that doesn't answer your question, or you get stuck, please come back and share a sample Excel file so we can help you further.
Mynda
Posted : 07/10/2020 12:40 am