After I select filter, the dbr.sum for column "Quantity" becomes 0.
select 'DBR.text' as 'DBR.text', 'drawstation+' as 'centername';
select 'DBR.subtitle' as 'DBR.subtitle', 'Product sales in the last 60 day' as 'Product sales in the last 60 day';
select 'dbr.sum', 'Total amount';
select 'dbr.sum', 'Quantity';
select 'dbr.summary.text', 'Month', 'Total';
select 'dbr.hdr', 'Month';
select 'dbr.search', 1;
select 'dbr.column.filter', 'Month', 'select';
select 'dbr.column.filter', 'Order date', 'select';
select 'dbr.column.filter', 'Product code', 'select';
select 'dbr.column.filter', 'Category', 'select';
select 'dbr.column.filter', 'English', 'text';
select 'dbr.column.filter', 'Chinese', 'text';
select 'dbr.column.filter', 'Student name', 'text';
select 'dbr.column.filter', 'Status', 'select';
select 'dbr.column.filter', 'Sales remarks', 'text';
select 'dbr.column.filter', 'Receipt remarks', 'text';
select '2022-07' as 'Month', '2022-07-13' as 'Order date', 'coupon' as 'Category', 'c100' as 'Product code', '100coupon' as 'English', '100禮券' as 'Chinese', '$100 coupon ' as 'Student name', '001' as 'ID', '3' as 'Quantity', 0.0 as 'Total amount', '' as 'Status', 'DS034-036 譚靖橋 ' as 'Sales remarks', null as 'Receipt remarks'
union all
select '2022-07', '2022-07-13', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS031-033 譚靖潼 已用', null
union all
select '2022-07', '2022-07-13', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS037-039 黃語彤', null
union all
select '2022-07', '2022-07-12', '其他', 'M 圍裙', 'M apron ', ' M 圍裙', '高浩銘 ', '10137', '1', 60.0, '', '', null
union all
select '2022-07', '2022-07-12', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS028-030 蘇煒琳', null
union all
select '2022-07', '2022-07-12', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '4', 0.0, '', 'Jul032-035 周晉陽己用', null
union all
select '2022-07', '2022-07-12', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '立言 闕', '10580', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-11', '其他', 'Bag', 'bag ', '畫袋', '林志忻 ', '10282', '1', 60.0, '', '', null
union all
select '2022-07', '2022-07-11', '顏料', '244', 'Mungyo粉彩-白', 'Mungyo粉彩-白', '林志忻 ', '10282', '1', 15.0, '', '', null
union all
select '2022-07', '2022-07-11', '其他', ' L 圍裙', 'L apron ', ' L 圍裙', '林志忻 ', '10282', '1', 60.0, '', '', null
union all
select '2022-07', '2022-07-11', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '4', 0.0, '', 'Jul024-027 周晉灝 已用', null
union all
select '2022-07', '2022-07-11', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS 022-024 鄭暐哲 已用', null
union all
select '2022-07', '2022-07-11', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS025-027 王安琪', null
union all
select '2022-07', '2022-07-11', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '鄭暐哲 ', '10579', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-10', 'coupon', 'c100', '100coupon', '100禮券', '周晉灝 ', '10354', '1', 0.0, '', 'Jul024-27', null
union all
select '2022-07', '2022-07-10', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '莊渂鎬 ', '10577', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-10', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'jul 028-030 闕仲言 已用', null
union all
select '2022-07', '2022-07-10', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '闕仲言 ', '10576', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-10', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '李曉彤 ', '10578', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-09', '其他', 'A3F', 'A3 folder', 'A3 folder', '李卓霖 ', '10088', '1', 100.0, '', '', null
union all
select '2022-07', '2022-07-09', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '4', 0.0, '', 'Jul 020-023 潘暐恆', null
union all
select '2022-07', '2022-07-09', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '4', 0.0, '', 'Jul1012-1015 張哲禮', null
union all
select '2022-07', '2022-07-09', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '4', 0.0, '', 'Jul008-011 趙栢諭', null
union all
select '2022-07', '2022-07-08', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', 'Mo Mo', '003', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-08', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '芊滺 李', '10575', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-08', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '陳 試堂', 'SID10576', '1', 0.0, 'Voided', '', null
union all
select '2022-07', '2022-07-08', '顏料', 'STL素描筆', 'STL acrylic ', 'STL素描筆', '許倪墁 ', '10497', '1', 130.0, '', '', null
union all
select '2022-07', '2022-07-08', '工具', 'Eraser', 'eraser', '素描擦膠', '許倪墁 ', '10497', '1', 20.0, '', '', null
union all
select '2022-07', '2022-07-08', '顏料', 'PW6', 'Liquitex塑膠彩-鈦白', 'Liquitex塑膠彩-鈦白', '李祉謙 ', '10179', '1', 30.0, '', '', null
union all
select '2022-07', '2022-07-08', '顏料', 'PV19', 'Liquitex塑膠彩-大紅', 'Liquitex塑膠彩-大紅', 'Mo Mo', '003', '1', 30.0, '', '', null
union all
select '2022-07', '2022-07-07', '顏料', 'PW6', 'Liquitex塑膠彩-鈦白', 'Liquitex塑膠彩-鈦白', '梁晨 ', '10001', '1', 30.0, '', '', null
union all
select '2022-07', '2022-07-07', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '封樂熙 ', '10574', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-07', '其他', 'M 圍裙', 'M apron ', ' M 圍裙', '吳芊穎 ', '10397', '1', 60.0, '', '', null
union all
select '2022-07', '2022-07-07', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS019 - 021 封樂熙', null
union all
select '2022-07', '2022-07-07', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '10', 0.0, '', 'DS690 - 699 Ansley Law', null
union all
select '2022-07', '2022-07-07', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '4', 0.0, '', 'Jul004-007 蔡希彤', null
union all
select '2022-07', '2022-07-06', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS016-018 薛鉫惠', null
union all
select '2022-07', '2022-07-06', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS 013-015 楊栢翹 已用', null
union all
select '2022-07', '2022-07-06', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '梁善涵 ', '10573', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-06', '手工包/精品', 'DIY388', '手工包$388', '手工包$388', '栢翹 楊', '10572', '1', 88.0, '', 'Mario cart DS013-015', null
union all
select '2022-07', '2022-07-06', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '栢翹 楊', '10572', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-04', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '游思行 ', '10571', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-04', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS010-012（10448）', null
union all
select '2022-07', '2022-07-03', '顏料', '244', 'Mungyo粉彩-白', 'Mungyo粉彩-白', '呂昕靜 ', '10227', '1', 15.0, '', '', null
union all
select '2022-07', '2022-07-03', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '8', 0.0, '', 'DS210-217 10567', null
union all
select '2022-07', '2022-07-03', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS007-009 10237', null
union all
select '2022-07', '2022-07-03', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '張濼妍 ', '10567', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-03', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '呂若菁 ', '10569', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-01', 'set裝', 'K&P Set', 'K/P Set', '新生套裝', '董夢橦 ', '10565', '1', 500.0, '', '', null
union all
select '2022-07', '2022-07-01', 'coupon', 'c100', '100coupon', '100禮券', '$100 coupon ', '001', '3', 0.0, '', 'DS004-006 10565 已用', null
union all
select '2022-06', '2022-06-27', '其他', 'Bag', 'bag ', '畫袋', 'Ryan Mak ', '10040', '1', 60.0, '', '', null;
