making a formula to do comparison for pivot table

**dcwan** · 09-09-2019, 07:30 PM

Hello

I'm struggling to get a formula in which I can drag down for the whole column.

In the provided attachment in "Pivot Table 2", I have a sample Pivot table and I'm trying to write a comparison formula in which it compares the value of one column versus another. However, when I write the formula for the first one and try to do a click-and-drag to copy to all of the cells in the comparative column, Excel is not updating with the rows in the formula.

Is this even possible in Excel or am I doing something wrong?

Thanks

**dcwan** · 09-12-2019, 06:09 PM

Hello,

So, I watched the provided Youtube link, and it suggests several options, including using the "Calculated Field" option to calculate what I would like to do.

However, it seems that when I use the "Calculated Field" for figuring out whether the number for one Pivot table column is greater than another Pivot table column, the logic is incorrect.

Why would that be the case?

PS: Unfortunately, I'm unable to upload my Excel file, but if that changes, I will upload the Excel file here.
PPS: Sample file uploaded and the changes that I made can be seen in the tab "Pivot Table 2", column E

making a formula to do comparison for pivot table

LinkBack

Thread Tools

Rate This Thread

Display

making a formula to do comparison for pivot table

Re: making a formula to do comparison for pivot table

Thread Information

Users Browsing this Thread

Similar Threads

Pivot table last year comparison

Problems making a formula for pivot table.

day on day variance comparison using pivot table

Pivot table Sales comparison over years

Help with comparison chart / pivot table

[SOLVED] Pivot Table row comparison

[SOLVED] pivot table comparison

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions