samedi 23 janvier 2021

Comparing Error Two Columns in Calculated Field in Pivot Table

I am trying to compare two columns in calculated field in pivot table as,

=IF(Storage Unit < 'Sales Target'; "Low";"Normal")

enter image description here

Even if two columns are in the values field it gives an value error.

Anyone has any opinion about the solution?

Thank you

Aucun commentaire:

Enregistrer un commentaire