I need to get break down of sales per customer per month!
How can I either get the data to manipulate it in Excel or generate the report
January 2021
Client A
General Sales Total £3,000.00
Engineer Time Total £1,000.00
Hardware Sales Total £20,000.00
Client B
General Sales Total £4,000.00
Engineer Time Total £2,100.00
Hardware Sales Total £18,000.00
Feb 2021
Client A
General Sales Total £3,000.00
Engineer Time Total £1,000.00
Hardware Sales Total £20,000.00
Client B
General Sales Total £4,000.00
Engineer Time Total £2,100.00
Hardware Sales Total £18,000.00