Hi,
I am querying two tables linked by Unique_ID. One table shows transaction volumes per row for each week. I want to see the last 13 weeks transaction volumes across in columns. So one machine per row with transaction volumes for the last 13 weeks. The weekending will appear as header in each column for these 13 weeks. For some reason, some lines are not pulling all the figures for the 13 weeks. Some machines show transaction volumes for say the 4th and 6th week but i know there should be transaction volumes for all.
Appreciate any help on this.