I am trying to compare two columns in the calculated field in the pivot table as:
=IF(Storage Unit < 'Sales Target'; "Low"; "Normal")
Insert Calculated Field (Screenshot)
Even if two columns are in the values field, it gives a value error.
Does anyone have any opinion about the solution?
Calculated fields in pivot tables cannot return text values, only sums (please take a look at this site for more information). It's stated there that
Sum is the only function available for a calculated field.
When it comes to a solution, I'd have another table with the pivot table's data imported to it, and with your IF formula to show "Low" or "Normal" sales.
