how to download multiple view/table data in one excel from apex page by clicking button using application process(AJAX)

Needed help on displaying Summary of Orders in a different region based on filter from Interactive report. If a filter on Order table is applied on column Product within IR. The summary region should show Total# of orders & Order value per the selected Product. How can I pass the filter value from IR to the below where condition? select p.product_name as OrderName, sum(quantity) as Order_Quantity, sum(quantity * p.list_price) sales from demo_order_items i join demo_product_info p on i.product_id= p.product_id Where p.product_id = 10 group by p.product_name;