I created a summary report with these fields:
TXTYPE
TXDATE
TOTALSUCCESS
TOTALFAILED
TOTALAMOUNT
I set TXTYPE as the Grouping Level. I want to add Extended Filter for TXDATE but I don't want to show the field in my report. How to achieve this?
Below is the query result I'm expecting from the report:
SELECT TXTYPE
,SUM(TXSUCCESS)
,SUM(TXFAILED)
,SUM(AMOUNT)
,SUM(TOTALAMOUNT)
FROM VIEW_RPT_DAILY_SUMMARY
WHERE TXDATE BETWEEN '2024-01-01' AND '2024-03-19'
GROUP BY TXTYPE