Hi Manideepak -
You'll probably get a quicker response if you post some sample data in a Tableau packaged workbook as well as a visual "mock up" of what you'd like your result to look like - It's a bit difficult to understand what you're trying to get accomplished "visually" based on the "verbal" description.
1 of 1 people found this helpful
When such groups overlap, it is necessary to create separate calculated fields with IF/ELSE statements. To demonstrate, I have attached an example Tableau Workbook and Excel file.
Let me know if you have any questions!