Show the total value of different lines in a line chart
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!
The auto-generated script (which was part of the app you've sent me) is containing a code block that is renaming the resident table sheet1, that was loaded in the first tab, to sheet1-1, then loading again from table source, auto-concatenating the tables and ignoring the explicite table name label 'sheet1'.
Probably that's not what you want to do, I only added the LinkTable to demonstrate your total line issue resolution.