Hi @mahabbat
I have moved this topic from cascading select to a different thread since it did not fit within that thread. As regards your query, I would strongly suggest you go through our support article on advanced calculate which is here
You can also look at some practical applications discussed in the following topics which would help you find your solution. Kindly do not hesitate to reach out with a sample form if you are experiencing any problems
Stephane