A long list of orders can hide the pattern you're looking for. A crosstab query puts states down the side, months across the top, and the sum of sales at each intersection. Watch my Crosstab Queries video to see how to build it with the Query Wizard.

For a complete step-by-step video tutorial on this topic, including additional examples and explanations, please visit https://599cd.com/2366.
No comments:
Post a Comment