How to filter dynamically in query table report?
I created the tabular view report using the query table below.
How can I do if I want to add Invoice Date filter in the report and pass the value to this query?
SELECT
"Customer ID",
SUM("Total (BCY)") as "Total Sales (BCY)",
COUNT("Invoice ID") as "Total Orders"
FROM "Invoices"
WHERE "Invoice Status" <> 'Void'
GROUP BY "Customer ID";