How to implement below query through yellowfin report builder
How to implement using report builder the below scenario:
SELECT T1.C1, SUM(T1.AMOUNT)
FROM(SELECT C1,C2, SUM(AMOUNT) AS AMOUNT
JOIN T2 ON T2.C3=AGGREGATE_TABLE.C3
GROUP BY T1.C1;
Please note that Aggregate_table is a huge table and I dont want to refer it twice.Also, I already have view containing this part:" AGGREGATE_TABLE JOIN T2 ON T2.C3=AGGREGATE_TABLE.C3"
Please advise.I need to implement it urgently.