I have the below sql statement:
SELECT SUM(Amount) AS collected_amount
,COUNT(distinct Account_number, Transcation_date) AS Total_Count
group by Snap_date, RSLT_CD
It can be run in sql server but gives error when running in datameer sql sheet.
I get the error 'Currently unable to handle CUBE, ROLLUP, or GROUPSETS.'
Can someone help me, thanks!
Please sign in to leave a comment.