Crosstab Query Examples (Financial Analysis)
Attached are some examples of how to use crosstab queries. All of the queries in the attachment are related to financial analysis reporting, but the general idea is there. I created these examples to familiarize myself more with the TRANSFORM and PIVOT statements. Personally, I think this crosstab query idea is the most difficult thing to get your head around with this program. I hope these examples help educate the community on this type of querying!
Some of the queries you will find in the example:
*Profit Analysis by Single Input Criteria Field
*Sales Numbers by Single Input Criteria Field
*Profit Analysis by Multiple Input Criteria Fields
*Sales Numbers by Multiple Input Criteria Fields
*Quarterly Analysis of Revenue by Calendar Year
*Average Monthly Sales Trend Analysis
Added New Trend Analysis Queries
Last edited by ajetrumpet; 07-02-2009 at 02:02 PM.