Padding data

Hi,

I've looked on the forums and I know I've seen how to do this before but I can't seem to find what I'm looking for.

I have some data where I have 3 figures, Males, Females and Persons - Persons is the sum of Males + Females. For some reason, the Persons figure has been dropped off one of the totals, but I know its the sum of females in this case.

Is there a method of padding this data using a calculated field in Tableau ?

and yes, I asked them over 2 weeks ago to just put the data back into the original datasource... Sometimes we just need to move on...

Peter