Hello @Siddhi_21, from what I can tell, this is in response to the other question you have posted in the community. Since you have started a new topic, we will close out the previous question.
Based on my initial assessment, there are 2 issues here with helping you find a solution.
We do not have an understanding of the data you are utilizing to build this pivot table, so creating a calculated field without that knowledge will not be possible. We are happy to guide you and assist you with your goal, but we need more information. You will have more success in the future receiving a solution if you provide any steps you have taken to accomplish the goal and possible errors you have faced in the process.
Also, part of your expected solution may not be possible if you are wanting to return different datatypes in a single field. If we create a calculated field, we could return an integer value OR a date value but not both. That is a limitation with QuickSight.
If you would like further assistance with this issue, we are happy to help. But can you please create a demo analysis in QuickSight Arena where we could test some alternative options and provide more detail about the problem you are facing.
Here is where you can find information about QuickSight Arena:
Thank you!