以下公式无法生成汇总模式:ShowAllRows() Filterfor("挂账日期","=",today()) and Filterfor("区域","<>","tm") and Filterfor("区域","<>","t") and Filterfor("区域","<>","b") and Filterfor("区域","<>","yd") and Filterfor("区域","<>","g") and Filterfor("区域","<>","s") and Filterfor("区域","<>","大区") and Filterfor("区域","<>","地办") and Filterfor("区域","<>","民康") and Filterfor("区域","<>","县办") and Filterfor("执行情况","<>","供不应求") and Filterfor("执行情况","<>","供不应求(压货)") and Filterfor("执行情况","<>","资信未审过") and Filterfor("执行情况","<>","合同不合格") and Filterfor("执行情况","<>","特批待审")and movecol("规格",1) and movecol("产品名称",3) and movecol("件数",2) and subtotal("规格","发货数量,件数,金额","2,2,2") and do(277)
而下面这个公式可以:ShowAllRows() and Filterfor("挂账日期","=",today()) and Filterfor("区域","<>","y") and Filterfor("区域","<>","b") and Filterfor("区域","<>","g") and Filterfor("区域","<>","s") and Filterfor("区域","<>","tm") and Filterfor("区域","<>","t") and Filterfor("区域","<>","连锁") and Filterfor("执行情况","<>","供不应求") and Filterfor("执行情况","<>","资信未审过") and Filterfor("执行情况","<>","合同不合格") and Filterfor("执行情况","<>","特批待审") and movecol("规格",1) and movecol("产品名称",3) and movecol("件数",2) and subtotal("规格","件数","2") and do(277)