Hi all,
I am in the process of trying to create a crosstab showing tht total cost and retail values the latest transaction (this is distinguished by time)
I have grouped the information to show you what data I am working with and the results I need to capture in my crosstab
Esaxmple one:
Total Cost Total Retail
Group1 Set ID – 201 4.50 9.00
Group2 Timestamp 10/12/2011 15:00:56
Detail – product, Qty, total cost, total retail, transaction ID,
Cola, 2, 1.00 2.00 1501
Biscuit, 1 0.50 1.00 1501
Sandwich, 2 1.00 2.00 1501
Total Cost Total Retail
Group1 Set ID – 201 6.50 9.00
Group2 Timestamp 10/12/2011 21:00:56
Detail – product, Qty, total cost, total retail, transaction ID,
Cola, 2, 2.00 2.00 1502
Biscuit, 1 0.50 1.00 1502
Sandwich,2 1.00 2.00 1502
In the crosstab I would show 6.50 and 9.00 respectively as this is latest time.
Example 2
Total Cost Total Retail
Group1 Set ID – 202 4.50 9.00
Group2 Timestamp 11/12/2011 16:00:56
Detail – product, Qty, total cost, total retail, transaction ID,
Apple, 2, 1.00 2.00 1503
Biscuit, 1 0.50 1.00 1503
Sandwich, 2 1.00 2.00 1503
Total Cost Total Retail
Group1 Set ID – 202 4.50 9.00
Group2 Timestamp 11/12/2011 20:00:56
Detail – product, Qty, total cost, total retail, transaction ID,
Orange, 1, 2.00 2.00 1500
Biscuit, 1 0.50 1.00 1500
Sandwich, 2 1.00 2.00 1500
In the crosstab I would show 4.50 and 9.00 respectively as this is latest time. I cannot use the transaction ID as the sequences are not reliable.
CROSSTAB EXAMPLE
Set_ID 10/12/2011 11/12/2011 12/12/2011
T.Cost T.Retail T.Cost T.Retail T.Cost T.Retail
201 7.50 9.00 - -
202 - 4.50 9.00 -
I hope thois makes sense and I will be happy to provide any further information.
Dannyb
I am in the process of trying to create a crosstab showing tht total cost and retail values the latest transaction (this is distinguished by time)
I have grouped the information to show you what data I am working with and the results I need to capture in my crosstab
Esaxmple one:
Total Cost Total Retail
Group1 Set ID – 201 4.50 9.00
Group2 Timestamp 10/12/2011 15:00:56
Detail – product, Qty, total cost, total retail, transaction ID,
Cola, 2, 1.00 2.00 1501
Biscuit, 1 0.50 1.00 1501
Sandwich, 2 1.00 2.00 1501
Total Cost Total Retail
Group1 Set ID – 201 6.50 9.00
Group2 Timestamp 10/12/2011 21:00:56
Detail – product, Qty, total cost, total retail, transaction ID,
Cola, 2, 2.00 2.00 1502
Biscuit, 1 0.50 1.00 1502
Sandwich,2 1.00 2.00 1502
In the crosstab I would show 6.50 and 9.00 respectively as this is latest time.
Example 2
Total Cost Total Retail
Group1 Set ID – 202 4.50 9.00
Group2 Timestamp 11/12/2011 16:00:56
Detail – product, Qty, total cost, total retail, transaction ID,
Apple, 2, 1.00 2.00 1503
Biscuit, 1 0.50 1.00 1503
Sandwich, 2 1.00 2.00 1503
Total Cost Total Retail
Group1 Set ID – 202 4.50 9.00
Group2 Timestamp 11/12/2011 20:00:56
Detail – product, Qty, total cost, total retail, transaction ID,
Orange, 1, 2.00 2.00 1500
Biscuit, 1 0.50 1.00 1500
Sandwich, 2 1.00 2.00 1500
In the crosstab I would show 4.50 and 9.00 respectively as this is latest time. I cannot use the transaction ID as the sequences are not reliable.
CROSSTAB EXAMPLE
Set_ID 10/12/2011 11/12/2011 12/12/2011
T.Cost T.Retail T.Cost T.Retail T.Cost T.Retail
201 7.50 9.00 - -
202 - 4.50 9.00 -
I hope thois makes sense and I will be happy to provide any further information.
Dannyb