0

Year over Year Sales

WantsToLearn

October 23, 2017 16:03

None

Follow

I need to accumulate year over year data for customers.

The final output needs to be something like the following:
Cust#, Cust Name, 2017 Data summed, 2016 Data summed.

Using the Customer Ledger Entry table, I need to
1. Sum all 2017 sales by customer
2. Sum all 2016 sales by customer

What is the best way to accomplish this? Could I create arrays of summarized sales by customer number and then do a union on them?

Thanks...

 

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Harry Lewis October 24, 2017 17:08

  Hi -

  Maybe something like this?

  {right-click and open the image to see a larger version}