Hi Sudhakar,

Find my approach as reference based on a view assumption i made stored in attached workbook version 9.3 located in the original thread.

I created a litte data set based on the assumptions yours has the same structure.

sudhakar reddy, if someone's reply is the solution to your question then please click on the Correct Answer button in that person's post.  This way everyone knows the question has been answered and it places the answer below the question so others that may have a similar problem can quickly get their problem fixed.  Also, it's the nice thing to do

If a post doesn't answer your question you can reply with additional information if necessary.  A dialog is a good thing and can hopefully lead to answering the question.  Thanks