老师好,我用下面的代码做合计统计,可是只有下面绿色的给出了合计的结果,其他各列均没有合计结果,请问为什么?谢谢!(我这个表有双层表头,不知是否影响合计统计?)
Tables("ProductionListing").Cols("T2D_PrimeProduction").GrandTotal = True
Tables("ProductionListing").Cols("T2D_SailLineProduction").GrandTotal = True
Tables("ProductionListing").Cols("T2D_ReshootProduction").GrandTotal = True
Tables("ProductionListing").Cols("T2D_UndershootProduction").GrandTotal = True
Tables("ProductionListing").Cols("T3D_PrimeProduction").GrandTotal = True
Tables("ProductionListing").Cols("T3D_SailLineProduction").GrandTotal = True
Tables("ProductionListing").Cols("T3D_InfillProduction").GrandTotal = True
Tables("ProductionListing").Cols("T3D_ReshootProduction").GrandTotal = True
Tables("ProductionListing").Cols("T3D_UndershootProduction").GrandTotal = True
Tables("ProductionListing").GrandTotal = True