3 Replies Latest reply: Jan 26, 2017 4:58 AM by Jia Sheng Loh RSS

    Line Chart

    Jia Sheng Loh

      Hello Expert!

       

      my data

       

      TransactionNumber    Agency   Amount

                                   1       AA        500

                                   2       BB        300

                                   3       CC       466

                                   4       GG       800

                                   5       AA        300

                                   6       DD        367

                                   7       EE        999

                                   8       EE        1035

                                   9       FF        100

                                 10       GG       200

                                  11      BB        700

                                  12      CC        1100

                                  13      AA        300

       

      I would like to create a line chart  with X axis as Agency and Y axis as sum each agency spend.

       

      How do I input my dimension and measure?

       

       

      Thanks!