Hi Rinki Brahmbhatt,
Sorry for the delay in answering your question.
I'm wondering if Rody Zakovich would be a good fit regarding this dashboard, design and pivot table. He's a fantastic Data Analyst, and might be able to help you on this complex question.
I haven't been able to fully solved your issue.
(Rody, if i'm wrong, my apologies! )
In order to get help in proper manner either please share Excel Data and desired output like pivot based on that data or share sample Tableau workbook.
The KPIs you wanna calculate are **** easy thing but needs at least proper sample data to calculate.