Yes, This is what I exactly want. Thank You.!!!
Would you mind helping me in another similar issue ?
I want to find out counts for each bank in the row. I believe that advance calculation may work using restarting at option.
But that option is disabled. Is it because of I am using student version of tableau ?
Is there any other alternate way to achieve this ?
It is not because of the version you are using, don't worry.
The restart at is grayed out because you need to have your calculation running along a date (a date field) in order to be able pick out at which level of the date you want your calculation to restart.
If you are able to provide a sample workbook of what you have I can try and help you out.
In the meantime, your best bet if I understood your bank question correctly is; if you have your banks each bank on a row, set the scope (compute using) of your calculation to the correct direction to give you the count.
Again, this is relative so if you show me how you built your view, I can try and help.
Cool, can I ask you to please mark my answer as correct?
I did. Thank You