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;