2 Replies Latest reply on Feb 17, 2013 9:21 PM by doh.doh

    Line chart with total

    doh.doh

      Hi everyone,

       

      I'm new to Tableau, hopefully my question makes sense!

       

      I have a table that looks something like this:

       

      Date             |   Bank Account       |  Amount

      ----------------------------------------------------------------------------

      1 Jan 2011    |   USD                    |  100

      4Jan 2011     |   GBP                    |  150

      21 Jan 2011  |    JPY                    |   175

      3 Feb 2011   |   USD                    |  -40

      5 Feb 2011   |   GBP                    |  250

      9 Feb 2011   |    JPY                    |   -75

       

      I have a line graph with:

      Columns = Month(Date),

      Rows = Sum(Amount),

      Color = Bank Account

       

      Right now there are 3 lines, each representing the different currencies

      How can I add a "total" line within the same line graph, such that it ignores the "Bank Account" column?

       

      Thanks!