I am trying to use the numbers on the right as a key to get the value from the matching “Dinstinct Count of Rma Number” in the pivot table. I am not sure about how to use this function and the videos I have watched have not helped. I also want it to output a zero, but I should be able to do that with an isna()

Here are the pivot table fields if that helps.

Any help would be appreciated.

​I am trying to use the numbers on the right as a key to get the value from the matching “Dinstinct Count of Rma Number” in the pivot table. I am not sure about how to use this function and the videos I have watched have not helped. I also want it to output a zero, but I should be able to do that with an isna()Here are the pivot table fields if that helps.Any help would be appreciated.  Read More

​