Hi, I have a list of 10 products, say A, B, C, D...... and I log the sales of each product every day.
I created a crosstab query such that products are in the rows and columns are two dates that I specify in the query.
I wanted to find out whats the difference in sales between these two dates...