# Best way to combine different reports into a single report

**URL:** <https://community.holistics.io/t/best-way-to-combine-different-reports-into-a-single-report/2274>\
**Category:** Ask the Community\
**Tags:** visualizations, data-model\
**Created:** [November 13, 2024, 3:59am UTC](https://community.holistics.io/t/best-way-to-combine-different-reports-into-a-single-report/2274 "2024-11-13T03:59:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![py1209](https://community.holistics.io/user_avatar/community.holistics.io/py1209/32/2113_2.png) [@py1209](https://community.holistics.io/u/py1209)\
**Post date:** [November 13, 2024, 3:59am UTC](https://community.holistics.io/t/best-way-to-combine-different-reports-into-a-single-report/2274/1 "2024-11-13T03:59:13Z")

</div>

hi there! i have three different reports that take place over a month-year basis.

for example:

report a - counts number of apples bought every month  
report b - counts number of bananas bought every month  
report c - counts number of cherries bought every month

is there a way to aggregate all these reports into a single report that adds up all the counts in a single month. or what is the easiest way to do this?

obviously, my use-case is much more complicated than just these simple counts as they include where statements and count distincts, but ideas?

–

one idea is to do a huge with as subquery for each report (with sub\_query as() ) and then combine them into a huge query

---

<div class="post-metadata">

**Author:** ![vinhhh](https://community.holistics.io/user_avatar/community.holistics.io/vinhhh/32/1085_2.png) [@vinhhh](https://community.holistics.io/u/vinhhh)\
**Post date:** [November 13, 2024, 8:29am UTC](https://community.holistics.io/t/best-way-to-combine-different-reports-into-a-single-report/2274/2 "2024-11-13T08:29:45Z")

</div>

Hi Paul,

Does using the date dim approach meet your needs? [Using a Date Dimension model | Holistics Docs (4.0)](https://docs.holistics.io/guides/using-date-dim-model#creating-date-dimension-model-in-holistics)

Best,

---

<div class="post-metadata">

**Author:** ![py1209](https://community.holistics.io/user_avatar/community.holistics.io/py1209/32/2113_2.png) [@py1209](https://community.holistics.io/u/py1209)\
**Post date:** [November 19, 2024, 7:26am UTC](https://community.holistics.io/t/best-way-to-combine-different-reports-into-a-single-report/2274/3 "2024-11-19T07:26:54Z")

</div>

great - thank you! --closed–

---

<div class="post-metadata">

**Author:** ![vinhhh](https://community.holistics.io/user_avatar/community.holistics.io/vinhhh/32/1085_2.png) [@vinhhh](https://community.holistics.io/u/vinhhh)\
**Post date:** [November 19, 2024, 7:36am UTC](https://community.holistics.io/t/best-way-to-combine-different-reports-into-a-single-report/2274/4 "2024-11-19T07:36:14Z")

</div>