If you have multiple cases of such data i.e you do this kind of analysis for various vendors/suppliers etc.. you can transform your data as to have those variables in table1 as columns instead of rows. This will make your overall calculations simple as tableau does everything in a columnar fashion.
There is also another solution using table calculations, you can see below.
I have used the your example data
Once you add this to the text box , change the following option to 'Table(Down)'
And this will be the result
Hope this helps.
Thanks for your quick response.
I have already done the above process and getting the details which you have shown in last screenshot.
However, the challenges I am facing is I need one more calculated field i.e. Mod-Impact which is sumOfSequence6 - SumOfSequect5.
Please check the second table in the screenshot I shared(Row-18). I need one more calculated row added between "ALL-MACRO" and "END".
Let me know if you find any solution to that.
Can Someone help me on this? or is this a Tableau limitation?
Your problem derives from how your data is structured so I'd suggest a pivot. As a rule of thumb a month should never be a field, it causes problems like the one you are currently experiencing.