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?

       

      Thanks,

      Josh