# Monthly breakdown of summed number field in table-style report?

**URL:** <https://community.fibery.io/t/monthly-breakdown-of-summed-number-field-in-table-style-report/6191>\
**Category:** Get Help\
**Created:** [May 16, 2024, 4:12pm UTC](https://community.fibery.io/t/monthly-breakdown-of-summed-number-field-in-table-style-report/6191 "2024-05-16T16:12:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [May 16, 2024, 4:12pm UTC](https://community.fibery.io/t/monthly-breakdown-of-summed-number-field-in-table-style-report/6191/1 "2024-05-16T16:12:06Z")

</div>

I’m sure it’s possible, I’m just find the reporting tools really confusing so I’m hoping for a little help.

Trying to create a table-style report on how many Hours (field) have been logged under a Project (entity), by month. Hours is a field on an Iteration (entity). Iterations have a Date (field) in a specific month. Iterations are linked to Projects via a M-1 relationship.

This is what I’m hoping it would look something like:

| Project Name | Total Hours | Hours (Jan 1 - Jan 31) | Hours (Feb 1 - Feb 28) | Hours (Mar 1 - Mar 31) | Hours (Apr 1 - Apr 30) | Hours (May 1 - May 31) | Hours (Jun 1 - Jun 30) | Hours (Jul 1 - Jul 31) | Hours (Aug 1 - Aug 31) | Hours (Sep 1 - Sept 30) | Hours (Oct 1 - Oct 31) | Hours (Nov 1 - Nov 30) | Hours (Dec 1 - Dec 31) |
| --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- |
| Project A | 12 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Project B | 7 | | 1 | | 3 | | 0.5 | 0.5 | | 1 | 1 | | |
| Project C | 22 | | 5 | 3 | 3 | | 2 | 1 | | 4 | 4 | | |

I know I can create this as a List view by creating a unique formula field for every single month on the Project database, but it seems crazy to have to do that.

---

<div class="post-metadata">

**Author:** ![Chr1sG](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/chr1sg/32/3941_2.png) [@Chr1sG](https://community.fibery.io/u/Chr1sG)\
**Post date:** [May 16, 2024, 4:30pm UTC](https://community.fibery.io/t/monthly-breakdown-of-summed-number-field-in-table-style-report/6191/2 "2024-05-16T16:30:01Z")

</div>

You need to make use of the ‘pivot’ function.  
 ![firefox_Fn11xQLbL9](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/6/62072f0e145ba46ee9f57c77a12856858964d731.gif)

and if you want to have the ‘unpivoted’ sum as well, that’s possible:  
 ![firefox_IKHE80TKxo](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/e/ea411196d81fd2aaac4b661a36b2756e025d27a4.gif)

---

<div class="post-metadata">

**Author:** ![interr0bangr](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/interr0bangr/32/8089_2.png) [@interr0bangr](https://community.fibery.io/u/interr0bangr)\
**Post date:** [May 16, 2024, 6:21pm UTC](https://community.fibery.io/t/monthly-breakdown-of-summed-number-field-in-table-style-report/6191/3 "2024-05-16T18:21:20Z")

</div>

Amazing, thank you!