8 Replies Latest reply: Oct 24, 2018 8:38 AM by Harshikha Kumar RSS

    Show the total value of different lines in a line chart

    Harshikha Kumar

      Hi! Is there a way that I can show a total line in a line chart. I have 2 dimensions represented as calendar year and Cost Center and a measure as Costs In which is basically the expense generated. In the line chart, I'm supposed to show a total line which will be the summation of the expenses of the cost centers. Example, if I select 2 cost centers, it should display a third line as well which will be the total. I found a link How do I show a total line in a line chart? but unfortunately, I'm getting 0 in the total.

       

      For reference, I'm attaching the file and the screenshot of the visualization that I currently have. Appreciate your help in advance!