dynamic tables in one report page

[elimey]

I have the following data model:

I need to create one page report that is structured as below:

What I need is a slicer on top of the page, and dynamic tables hiding and unhiding based on that slier selection. 

Note: The tables (FX,LC, SC, etc. ) have a differnet format. Meaning, I can't append ot UNION them. 

How can ahieve the most optimum report design in this case?

[Bmejia]

If all four tables have the same data or at least going to have the same data shown then I would merge all the records into one table, or at least the records that are going to be shown on the tables.  Otherwise you are going to have to use bookmarks to hide the tables when you select a specific category.

Watch this video it should help you and you can find more online.
https://www.youtube.com/watch?v=o06fbKPgRXM

[elimey]

Hi Bmejia, 
I have mentioned in my post that the tables have different formats. I can't union them