Here is the screen shot of my data (I also attached it in excel format). I am trying to calculate admit_1000, which is a calculated field admitcount/mmos*12000.
I create that field in Tableau calculation (represented here as a FYI). I need this metric calculated and displayed as Line graph at IDN level.
There will be 3 lines: Current Year, Previous Year and Current Year Total Network with cumulative YTD calculations
The idea is that Network Line will remain constant for each month regardless of what IDN I choose in the filter.
Here is what I intend to see:
YTD Cumulative current year,Previous Year and Current Network Year: For example MGH,120: Jan'17=22,Feb'17= 22+8.
I created Running_sum calculations. But however they don't work. Can you please help?
Here is what I wanted to see (I would like to see Network current year added here as well).