1 Reply Latest reply: May 15, 2014 10:13 AM by roldgoldberg13 _ RSS

    Pivot Table type formatting

    roldgoldberg13 _

      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?