Aggregation Logic

if saleChannel = 0
        group by legacyCategoryCode
            sales: {
                saleItems: [
                    {
                        - saleChannel = saleItems.saleChannel where saleItemType="Sale"
                        - categoryCode = saleItems.categoryCode where saleItemType="Sale"
                        - subCategoryCode = saleItems.subCategoryCode where saleItemType="Sale"
                        - productCode = saleItems.productCode where saleItemType="Sale"
                        - legacyProductCode = saleItems.legacyProductCode where saleItemType="Sale"
                        - legacyCategoryCode = saleItems.legacyCategoryCode where saleItemType="Sale"
                        - salesQuantity = sum(saleItems.quantity where saleItemType="Sale")
                    }
                ],
                - totalSalesAmountIncludingTax = sum(saleItems.amount where saleItemType="Sale")
                - totalSalesAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Sale")
                - totalSalesQuantity = sum(saleItems.quantity where saleItemType="Sale")
            }
            refunds: {
                refundItems: [
                    {
                        - saleChannel = saleItems.saleChannel where saleItemType="Refund"
                        - categoryCode = saleItems.categoryCode where saleItemType="Refund"
                        - subCategoryCode = saleItems.subCategoryCode where saleItemType="Refund"
                        - productCode = saleItems.productCode where saleItemType="Refund"
                        - legacyProductCode = saleItems.legacyProductCode where saleItemType="Refund"
                        - legacyCategoryCode = saleItems.legacyCategoryCode where saleItemType="Refund"
                        - refundAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Refund"
                        - discountAmountIncludingTax = sum(saleItems.priceAdjustments.amount where saleItemType="Refund")
                        - discountAmountExcludingTax = sum(saleItems.priceAdjustments.netAmount where saleItemType="Refund")
                        - refundQuantity = sum(saleItems.quantity where saleItemType="Refund")
                    }
                ],
                - totalRefundAmountIncludingTax = sum(saleItems.amount where saleItemType="Refund")
                - totalRefundAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Refund")
                - totalRefundQuantity = sum(saleItems.quantity where saleItemType="Refund")
            }
    if saleChannel != 0
        group by legacyProductCode
            sales: {
                saleItems: [
                    {
                        - saleChannel = saleItems.saleChannel where saleItemType="Sale"
                        - categoryCode = saleItems.categoryCode where saleItemType="Sale"
                        - subCategoryCode = saleItems.subCategoryCode where saleItemType="Sale"
                        - productCode = saleItems.productCode where saleItemType="Sale"
                        - legacyProductCode = saleItems.legacyProductCode where saleItemType="Sale"
                        - legacyCategoryCode = saleItems.legacyCategoryCode where saleItemType="Sale"
                        - netAmount = sum(saleItems.originalNetAmount where saleItemType="Sale")
                        - discountAmount = sum(saleItems.priceAdjustments.netAmount where saleItemType="Sale")
                        - salesQuantity = sum(saleItems.quantity where saleItemType="Sale")
                    }
                ],
                - totalSalesQuantity = sum(saleItems.quantity where saleItemType="Sale")
                - totalSalesAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Sale")
                - totalSalesQuantity = sum(saleItems.quantity where saleItemType="Sale")
            }
            refunds: {
                refundItems: [
                    {
                        - saleChannel = saleItems.saleChannel where saleItemType="Refund"
                        - categoryCode = saleItems.categoryCode where saleItemType="Refund"
                        - subCategoryCode = saleItems.subCategoryCode where saleItemType="Refund"
                        - productCode = saleItems.productCode where saleItemType="Refund"
                        - legacyProductCode = saleItems.legacyProductCode where saleItemType="Refund"
                        - legacyCategoryCode = saleItems.legacyCategoryCode where saleItemType="Refund"
                        - refundAmountIncludingTax = sum(saleItems.amount where saleItemType="Refund"
                        - refundAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Refund"
                        - discountAmountIncludingTax = sum(saleItems.priceAdjustments.amount where saleItemType="Refund")
                        - discountAmountExcludingTax = sum(saleItems.priceAdjustments.netAmount where saleItemType="Refund")
                        - refundQuantity = sum(saleItems.quantity where saleItemType="Refund")
                    }
                ],
                - totalRefundAmountIncludingTax = sum(saleItems.amount where saleItemType="Refund")
                - totalRefundAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Refund")
                - totalRefundQuantity = sum(saleItems.quantity where saleItemType="Refund")
            }

if saleChannel = 0
        group by subCategoryCode
            sales {
                saleItems: [
                    {
                        - saleChannel = saleItems.saleChannel where saleItemType="Sale"
                        - categoryCode = saleItems.categoryCode where saleItemType="Sale"
                        - subCategoryCode = saleItems.subCategoryCode where saleItemType="Sale"
                        - productCode = saleItems.productCode where saleItemType="Sale"
                        - legacyProductCode = saleItems.legacyProductCode where saleItemType="Sale"
                        - legacyCategoryCode = saleItems.legacyCategoryCode where saleItemType="Sale"
                        - salesAmountIncludingTax = sum(saleItems.amount where saleItemType="Sale")
                        - salesAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Sale")
                        - discountAmountIncludingTax = sum(saleItems.priceAdjustments.amount where saleItemType="Sale")
                        - discountAmountExcludingTax = sum(saleItems.priceAdjustments.netAmount where saleItemType="Sale")
                        - salesQuantity = sum(saleItems.quantity where saleItemType="Sale")
                    }
                ],
                - totalSalesAmountIncludingTax = sum(saleItems.amount where saleItemType="Sale") + sum(saleItems.originalAmount where saleItemType="Sale")
                - totalSalesAmountExcludingTax = sum(saleItems.amount where saleItemType="Sale") + sum(saleItemType.originalNetAmount where saleItemType="Sale")
                - totalSalesQuantity = sum(saleItems.quantity where saleItemType="Sale")
            }
            refunds: {
                refundItems: [
                    {
                        - saleChannel = saleItems.saleChannel where saleItemType="Refund"
                        - categoryCode = saleItems.categoryCode where saleItemType="Refund"
                        - subCategoryCode = saleItems.subCategoryCode where saleItemType="Refund"
                        - productCode = saleItems.productCode where saleItemType="Refund"
                        - legacyProductCode = saleItems.legacyProductCode where saleItemType="Refund"
                        - legacyCategoryCode = saleItems.legacyCategoryCode where saleItemType="Refund"
                        - refundAmountIncludingTax = sum(saleItems.amount where saleItemType="Refund"
                        - refundAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Refund"
                        - discountAmountIncludingTax = sum(saleItems.priceAdjustments.amount where saleItemType="Refund")
                        - discountAmountExcludingTax = sum(saleItems.priceAdjustments.netAmount where saleItemType="Refund")
                        - refundQuantity = sum(saleItems.quantity where saleItemType="Refund")
                    }
                ],
                - totalRefundAmountIncludingTax = sum(saleItems.amount where saleItemType="Refund") + sum(saleItems.originalAmount where saleItemType="Refund")
                - totalRefundAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Refund") + sum(saleItem.originalNetAmount where saleItemType="Refund")
                - totalRefundQuantity = sum(saleItems.quantity where saleItemType="Refund")
            }
    if saleChannel != 0
        group by productCode
            sales: {
                saleItems: [
                    {
                        - saleChannel = saleItems.saleChannel where saleItemType="Sale"
                        - categoryCode = saleItems.categoryCode where saleItemType="Sale"
                        - subCategoryCode = saleItems.subCategoryCode where saleItemType="Sale"
                        - productCode = saleItems.productCode where saleItemType="Sale"
                        - legacyProductCode = saleItems.legacyProductCode where saleItemType="Sale"
                        - legacyCategoryCode = saleItems.legacyCategoryCode where saleItemType="Sale"
                        - salesAmountIncludingTax = sum(saleItems.originalAmount where saleItemType="Sale")
                        - salesAmountExcludingTax = sum(saleItems.originalNetAmount where saleItemType="Sale")
                        - salesQuantity = sum(saleItems.quantity where saleItemType="Sale")
                    }
                ],
                - totalSalesAmountIncludingTax = sum(saleItems.amount where saleItemType="Sale")
                - totalSalesAmountExcludingTax = sum(saleItems.amount where saleItemType="Sale")
                - totalSalesQuantity = sum(saleItems.quantity where saleItemType="Sale")
            }
            refunds: {
                refundItems: [
                    {
                        - saleChannel = saleItems.saleChannel where saleItemType="Refund"
                        - categoryCode = saleItems.categoryCode where saleItemType="Refund"
                        - subCategoryCode = saleItems.subCategoryCode where saleItemType="Refund"
                        - productCode = saleItems.productCode where saleItemType="Refund"
                        - legacyProductCode = saleItems.legacyProductCode where saleItemType="Refund"
                        - legacyCategoryCode = saleItems.legacyCategoryCode where saleItemType="Refund"
                        - refundAmountIncludingTax = sum(saleItems.originalAmount where saleItemType="Refund"
                        - refundAmountExcludingTax = sum(saleItems.originalNetAmount where saleItemType="Refund"
                        - discountAmountIncludingTax = sum(saleItems.priceAdjustments.amount where saleItemType="Refund")
                        - discountAmountExcludingTax = sum(saleItems.priceAdjustments.netAmount where saleItemType="Refund")
                        - refundQuantity = sum(saleItems.quantity where saleItemType="Refund")
                    }
                ],
                - totalRefundAmountIncludingTax = sum(saleItems.amount where saleItemType="Refund") + sum(saleItems.originalAmount where saleItemType="Refund")
                - totalRefundAmountExcludingTax = sum(saleItems.netAmount where saleItemType="Refund") + sum(saleItem.originalNetAmount where saleItemType="Refund")
                - totalRefundQuantity = sum(saleItems.quantity where saleItemType="Refund")
            }