I cant seem to remove the entry (sales) in the department row so that it can reflect exactly what was given
in the example. Please how can I resolve this?
Oh, so very close! You can do one of two things:
If you're just trying to blank out the line item use the formula BLANK and it will remove everything. Then delete the formula.
already tried bith solutions none worked. the code is coming back as invalid
Does the Department list contain codes?
Mapping Department Code in the import or using PARENT(ITEM()) should return the list item but only if the list contains codes.
Check if if the code is missing reload the Department list and try again.