# Is there a way to Model with 2 Fact Tables in same dataset? **URL:** \ **Category:** Q&A\ **Tags:** data-preparation, quick-sight\ **Created:** [August 19, 2022, 2:03pm UTC](https://community.amazonquick.com/t/is-there-a-way-to-model-with-2-fact-tables-in-same-dataset/5507 "2022-08-19T14:03:47Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![kwarren35](https://avatars.discourse-cdn.com/v4/letter/k/f19dbf/32.png) [@kwarren35](https://community.amazonquick.com/u/kwarren35)\ **Post date:** [August 19, 2022, 2:03pm UTC](https://community.amazonquick.com/t/is-there-a-way-to-model-with-2-fact-tables-in-same-dataset/5507/1 "2022-08-19T14:03:48Z")
What is the best practice way currently in Quick Sight to prep your data in a way to show comparison numbers? For Example, Quick Sight Visualizations only allow for 1 dataset to be used to bring in fields to display content in, so if your Sales and Sales Forecast numbers are in 2 different fact tables, how can we get this into 1 dataset? Ideas: 1. Prep your data before bringing into Quick Sight, by creating a merge summary table that displays both sales and sales forecast numbers by yearmonth. ? ---
**Author:** ![Karthik\_Tharmarajan](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/karthik_tharmarajan/32/3282_2.png) [@Karthik\_Tharmarajan](https://community.amazonquick.com/u/Karthik_Tharmarajan)\ **Post date:** [August 22, 2022, 9:33pm UTC](https://community.amazonquick.com/t/is-there-a-way-to-model-with-2-fact-tables-in-same-dataset/5507/2 "2022-08-22T21:33:12Z")
Hi, Although you can use multiple datasets to build a dashboard, a visual in Quick Sight is tied to one dataset. Depending on your use case you will need to merge required data into a single dataset that you can visualize from a chart/visual. This merge process can happen either outside of Quicksight or you can bring then in as two separate datasets and join them within Quick Sight if there is a relationship that can be established. Regards, Karthik