# Resource Management summaries **URL:** \ **Category:** Ask the Community\ **Created:** [June 20, 2018, 3:04pm UTC](https://connect.superhuman.com/t/resource-management-summaries/1223 "2018-06-20T15:04:48Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Phil\_White](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/phil_white/32/1288_2.png) [@Phil\_White](https://connect.superhuman.com/u/Phil_White)\ **Post date:** [June 20, 2018, 3:04pm UTC](https://connect.superhuman.com/t/resource-management-summaries/1223/1 "2018-06-20T15:04:48Z")
Hi All, I have a table where I have a bunch of activities for our consultants - some confirmed (checkbox column), some complete (separate checkbox column) with each row containing the Task, Location, Start Date, Duration and End Date (calculated from start + duration) I am trying to create a summary view to ensure we do not over allocate people on a monthly basis. I would like to show the consultant on the left (I have a row per consultant looking up from the All Consultants table in a different section) which when you select the consultant it then calculates the number of days confirmed, unconfirmed, total and % offsite (location can be Office or Offsite) on a per month basis. Cannot figure out how to do this in Code (I have this running in Excel at the moment). I have a hidden MonthName column which uses the MonthName formula to calculate the month the start date Anyone have any ideas? ---
**Author:** ![maria](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/maria/32/6602_2.png) [@maria](https://connect.superhuman.com/u/maria)\ **Post date:** [June 20, 2018, 6:47pm UTC](https://connect.superhuman.com/t/resource-management-summaries/1223/2 "2018-06-20T18:47:24Z")
I definitely recommend using the filter by thisRow formula here. [This article](https://help.coda.io/formulas/using-the-filter-formula) goes through an example in the latter half. Hope that helps!