Add a calculated column to a pivot table in pandas

Question

Hi I am trying to create new columns to a multi-indexed pandas pivot table to do a countif statement (similar to excel) depending if a level of the index contains a specific string. This is the sample data:

df = pd.DataFrame({'City': ['Houston', 'Austin', 'Hoover','Adak','Denver','Houston','Adak','Denver'],
                   'State': ['Texas', 'Texas', 'Alabama','Alaska','Colorado','Texas','Alaska','Colorado'],
                   'Name':['Aria', 'Penelope', 'Niko','Susan','Aria','Niko','Aria','Niko'],
                   'Unit':['Sales', 'Marketing', 'Operations','Sales','Operations','Operations','Sales','Operations'],
                   'Assigned':['Yes','No','Maybe','No','Yes','Yes','Yes','Yes']},
                 columns=['City', 'State', 'Name', 'Unit','Assigned'])

pivot=df.pivot_table(index=['City','State'],columns=['Name','Unit'],values=['Assigned'],aggfunc=lambda x:', '.join(set(x)),fill_value='')

and this is the desired output (in screenshot). Thanks in advance!