I have a table that contains:
1.Location IDs (494, 1011, 1053)
2.Fee Types (Transaction, Enabler and Misc. Fees)
3.Transaction Amount (Dollar value)
There can be multiple transactions for a location that have the same fee type. I'm trying to create a summary view that totals transaction amounts for a location for each fee type. (Create one line for 494 Enabler fee total amount, one line for 494 Transaction fee total amount, etc.)
Does anyone know how I can go about creating this, or can point me to an example model that does something similar?