LS NAV Views - Transaction per Day / Store

SELECT        COUNT([Transaction No_]) AS TrxCount, Date, [Store No_], [POS Terminal No_]
FROM            [Transaction Header]
GROUP BY Date, [Store No_], [POS Terminal No_]
HAVING        (Date > GETDATE() - 5)
ORDER BY Date