Quick Report how to use dynamic filter in pivot? Hello,I'm struggling with making my report work to use a dynamic search filter under Pivot for part_no. Does anyone have experience with this? Note, I don't use pivot in SQL very often and tried different approaches. I tried creating a subquery for shop_ord without success. I've also tried using regex: part_no IN (SELECT trim(regexp_substr('&part_no','[^;]+', 1, level)) AS q FROM dualCONNECT BY regexp_substr('&part_no', '[^;]+', 1, level) IS NOT NULL ) I also tried to use query flags without any success. So, I'm a bit stuck and unsure whether this can be done. Does anyone have experience with this? My SQL: WITH weeks AS ( SELECT TO_CHAR(TRUNC(SYSDATE, 'D') + (8 - TO_CHAR(SYSDATE, 'D')), 'IW') + (LEVEL - 1) AS week_number FROM DUAL CONNECT BY LEVEL <= 21),data AS ( SELECT TO_CHAR(TRUNC(s.REVISED_DUE_DATE, 'IW'), 'IW') AS week_number, s.PART_NO, SUM(NVL(s.REMAINING_NET_SUPPLY_QTY, 0)) AS total_qty FROM SHOP_ORD s WHERE s.STATE IN ('Planned', 'Released', 'Reserved', 'Started') AND s.REVIS