October 6, 2020
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.
July 16, 2010
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.