I have a dataset that contains columns such as manufacturer, date, location and model. I have a requirement that I need to create a paginated report. If a user selects two manufacturers, the data related to both manufacturers should not be aggregated into a single table or visual. Instead, it should be displayed on separate pages for each manufacturer.
For example, I created a visual table type that contains the manufacturer, date, location, and model. If a user selects two manufacturers like Ford and Tata:
Manufacturer | Date | Location | Model
Ford | Jan 25 | Ind | X2c
Manufacturer | Date | Location | Model
Tata | Jan 05 | Ind | D23
Each should be on a separate page. Is this Possible to do?