[Bars]

while select itemId, inventDimId from salesLine
        group by itemid,inventDimId
            where salesLine.dataAreaId == 'dat'
              && salesLine.SalesStatus == SalesStatus::Invoiced
                && salesLine.ConfirmedDlv >= startDate
                   && salesLine.ConfirmedDlv <= endDate

есть отдельныйиндекс по itemid и inventDimId