Forum

Notifications
Clear all

Pivot Tables: Compare two different columns

2 Posts
2 Users
0 Reactions
684 Views
(@morrismoose)
Posts: 1
New Member
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
(@mynda)
Posts: 4761
Member Admin
 

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
Share: