Dashboards
Power Pivot
February 18, 2017
All,
I need help with an analysis. Attached. The pivot table is grabbing leasing data from a building. It shows the average rent and average rent/sf achieved during each Quarter of the property's opening. These averages are a little misleading only because in any given quarter there could be different units and weird one-off situation. To smooth out the data, I wanted to show the average of the entire property at the specific time period during the lease up (almost like a rolling average but the time period stays fixed at the initial opening). For example, 2nd quarter 2016 would be the average of all rents achieved since the beginning of the lease up (q2 2014) through 2nd quarter 2016. As you'll see i have a table the has the respective $/SF (column K and then in Column N i have averaging those averages which is wrong. But i don't know how to do it right.
How do i do this with manually going into the data ?
VIP
April 21, 2015
Dashboards
Power Pivot
February 18, 2017
VIP
April 21, 2015
What I do after the sequence 'selecting file-click upload-click submit reply' is leaving the item, then come back and then see if the attachment really is in the post I submitted. So a kind of 'final check' after leaving and coming back to be sure it's in my reply or new post. And in your post there is nothing, you can see for yourself!
We wait until we see your contribution!
1 Guest(s)