0 Replies Latest reply on Aug 12, 2013 1:28 AM by Yuriy Gavrilov

Calculation of weekly repeat sales by distinct customer and location?

Hi,

I have a kind of table below as a data source. The total count of Sites is 85, and overal count of rows is 219 000 000 for 1 year data.

The goal is to calculate repeat sales by week. Need to visualise sum of sales and count of distinct client whith come back to the same site on next week. In my example this is client 1 whith come back 2 times to site A. In additional will be great to calculate % of reapet sales client to all clients by site and week. Sites and weeks will be as a parameters with multiselection optioon.

 Site ID Customer ID week Sales A 1 1 100 A 1 2 200 A 1 3 300 B 2 1 100 B 3 1 100 B 4 2 100 B 5 2 200 B 6 3 100 C 7 1 200 C 8 2 300 C 9 3 200 A 10 1 100 A 11 2 200 A 12 3 300

I imagine that the results table could be something like this:

 Week 1 2 3 Site ID repeat sales (Client) repeat sales (Sales Amount) % to total sales amount repeat sales (Client) repeat sales (Sales Amount) % to total sales amount repeat sales (Client) repeat sales (Sales Amount) % to total sales amount A 1 100 50% 1 200 50% 1 300 50% B 0 0 0 0 0 0 0 0 0 C 0 0 0 0 0 0 0 0 0

Could somebody suggest a solution for this case?

Thanks for any help

Yura

Yura