How can I add the dbr.report in the value of the Total column too? Thanks
select 'dbr.export.options', 'orientation', 'landscape';
select 'DBR.text' as 'DBR.text', 'Eye Level Interactive Education Centre (D.Park)' as 'group_concat( centername )';
select 'dbr.text', 'From: 2024-05-01 to 2024-10-31';
select 'dbr.text', 'Original Class Date 按原課堂日子';
select 'dbr.text', '1.1 - Total revenue corresponding to the classes and sales 當月課堂所計算盈利';
select 'dbr.text', '1.2 - Total paid revenue corresponding to the classes and sales 當月課堂所計算盈利(只包括已繳款發票)';
select 'dbr.text', '2.1 - Total payment received within the month(s) 當月收款';
select 'dbr.text', ' ';
select 'dbr.search', 1;
select 'dbr.subtitle', 'Monthly Revenue/Payment received 每月盈利/收款';
select 'dbr.crosstab', '[month]';
select 'dbr.hsum', '[value]';
select 'dbr.colstyle', '[value]', '[white-space:pre; width:1000]';
select 'dbr.colstyle', '[type]', '[white-space:nowrap]';
select 'dbr.report', 'sp_DBR_revenue_details', '[value]', 'popup', 'Center=(Center)', 'inMonth=month', 'inType=type', 'inMakeupConsidered=(makeupConsidered)', 'intypeoption=(in_typeoption)';
select '1.1 - Revenue 盈利 (All invoice 全部發票)' as 'Type 類別[type]', '2024-05' as 'Payment/Revenue month 月份[month]', 220022.1 as '[value]'
union all
select '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', '2024-05', 220022.1
union all
select '2.1 - Payment received 收款 ', '2024-05', 284326.0
union all
select '1.1 - Revenue 盈利 (All invoice 全部發票)', '2024-06', 215361.3
union all
select '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', '2024-06', 215351.0
union all
select '2.1 - Payment received 收款 ', '2024-06', 181443.0
union all
select '1.1 - Revenue 盈利 (All invoice 全部發票)', '2024-07', 230152.1
union all
select '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', '2024-07', 230151.9
union all
select '2.1 - Payment received 收款 ', '2024-07', 129078.0
union all
select '1.1 - Revenue 盈利 (All invoice 全部發票)', '2024-08', 226095.8
union all
select '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', '2024-08', 226095.7
union all
select '2.1 - Payment received 收款 ', '2024-08', 176244.0
union all
select '1.1 - Revenue 盈利 (All invoice 全部發票)', '2024-09', 203063.9
union all
select '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', '2024-09', 203063.4
union all
select '2.1 - Payment received 收款 ', '2024-09', 175921.0
union all
select '1.1 - Revenue 盈利 (All invoice 全部發票)', '2024-10', 191351.2
union all
select '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', '2024-10', 176410.4
union all
select '2.1 - Payment received 收款 ', '2024-10', 107479.0;
select 'dbr.chart', 'MSline', 'Chart 圖表', 1500, 500;
select '202405' as 'Financial_month', '1.1 - Revenue 盈利 (All invoice 全部發票)' as 'type', 220022.1 as '[value]'
union all
select '202405', '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', 220022.1
union all
select '202405', '2.1 - Payment received 收款 ', 284326.0
union all
select '202406', '1.1 - Revenue 盈利 (All invoice 全部發票)', 215361.3
union all
select '202406', '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', 215351.0
union all
select '202406', '2.1 - Payment received 收款 ', 181443.0
union all
select '202407', '1.1 - Revenue 盈利 (All invoice 全部發票)', 230152.1
union all
select '202407', '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', 230151.9
union all
select '202407', '2.1 - Payment received 收款 ', 129078.0
union all
select '202408', '1.1 - Revenue 盈利 (All invoice 全部發票)', 226095.8
union all
select '202408', '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', 226095.7
union all
select '202408', '2.1 - Payment received 收款 ', 176244.0
union all
select '202409', '1.1 - Revenue 盈利 (All invoice 全部發票)', 203063.9
union all
select '202409', '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', 203063.4
union all
select '202409', '2.1 - Payment received 收款 ', 175921.0
union all
select '202410', '1.1 - Revenue 盈利 (All invoice 全部發票)', 191351.2
union all
select '202410', '1.2 - Revenue 盈利 (Paid invoice only 只包括已繳款發票)', 176410.4
union all
select '202410', '2.1 - Payment received 收款 ', 107479.0;
