msharma

Thanks for the clarification. I tried to create a new table in DOMO SQL using the following syntax in sql : SELECT `G_L Account No_`,`AcctLen`,`fund#`, `Fund No_`,`Dept#`, `Obj#`, `Global Dimension 1 Code`, `Posting Date`, `Description`, `Amount`, `Transaction Type`, `Actual_Amt`, `Budget_Amt`, sum(sum(case when…

Thank you. It works. I have a follow up question. How to add hardcoded dates that the amount is summed for a period specified, even when the chard is filtered on for different dates. e.g. I will like to always get the sum of transactions Type 1 between the period of Jan-01-2020 and Dec-31-2021, even when the filter on the…