Hi all
I have a data table that contains properties, their size in square footage, a budget item, a budget amount, and a per square foot amount. I need to show the correct per square foot numbers in a pivot table and I can't figure out how to do this. For example, if a building has 3,000 SF, and has two budget items of $10,000 and $5,000, I can't find a way to show an accurate per square foot number for each individual line item AND grand totals. The total should show $5 per square foot (i.e. $15,000 divided by 3,000 square feet). However, since it totals the SF of each line item, it shows $15,000 divided by 6,000 square feet, or $2.50 per square foot.
Any ideas?
Bookmarks