Skip to Content
0
Nov 30, 2016 at 04:32 PM

Query Help Customer Sales/Invoice

54 Views

Hello, i'm new to this forum but wondering if someone is able to help me or has possibly done this before? I searched the forum but couldn't find anything similar to this.

I am after a query that can display the following if possible.

List all Customers.

  • Current month total sales/invoice including GP%
  • Last Months total sales/invoice including GP%
  • Last 12 months total sales/invoice including GP%
  • 3 month average of sales/invoice including GP%
  • 6 month average of sales/invoice including GP%