Untitled

-- Transactional level detail for New Business and Renewal
SELECT 
    Transaction_Date,
    Transaction_Type,
    Agency_ID,
    State,
    Class,
    Channel,
    Product,
    GWP,
    Terrorism_Levy,
    FSL,
    GST,
    Stamp_Duty,
    Commission,
    Commission_GST,
    Accounting_Month
FROM 
    transactions
WHERE 
    Transaction_Type IN ('New Business', 'Renewal')
AND 
    Accounting_Month = '2024-08-01'; -- Replace with the required accounting month