I've got a flat file of data for property occupancy numbers that I need to put into a pivot table. The occupancy is provided, but I have groupings that end up just summing the Occupancy %'s:
The 2163% is the problem (bunch of hidden rows for simplicity).
The easy answer is a calculated field, but since I'm pulling from a flat file, I dropped Field into the Columns to show all the data. In the Calculated Field box, only "Field" is shown as a calculation source. Is there a way around this? I just need my formula to be =1 - (Vacancies / Available)
thanks
The 2163% is the problem (bunch of hidden rows for simplicity).
The easy answer is a calculated field, but since I'm pulling from a flat file, I dropped Field into the Columns to show all the data. In the Calculated Field box, only "Field" is shown as a calculation source. Is there a way around this? I just need my formula to be =1 - (Vacancies / Available)
thanks