Home

Percentage calculation in pivot table for a growing time series

elansr
Occasional Visitor

Howdy,

 

I'm trying to create a pivot table showing percentage occupancy across a portfolio of residential properties. The viewer should have the ability to slice the data however they want. I'm unsure how to accomplish this. The basic idea and issues are as follows:

 

  • Everyday we get an update on the occupancy across the portfolio
  • Some of the properties were added over time so the total number of units has changed multiple times
  • I want to create a pivot table and pivot chart that grow daily to accommodate the newly reported occupancy. The pivot chart and table should show occupancy percentage which are calculated by dividing the occupancy for the period by the number of units during the period. Since I can't add percentages, I'm struggling to figure out how to accomplish this.
  • I want to eventually post the pivot chart with the slicing functionality to a sharepoint site  

Here is an example of the data. Everyday there will be another column added. Properties start showing occupancy from the day they are acquired.

Example.png

Thanks,

 

elansr

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies