Forum Discussion

ritendersingh2's avatar
ritendersingh2
Copper Contributor
Nov 27, 2021

Excel Tables and Relationship

Hello - I am using excel 2016 standard version, which doesn't have a power pivot, how can I create a pivot table from two tables having duplicate values in each table, I cannot create a relationship ...
excel
ritendersingh2's avatar
ritendersingh2
Copper Contributor
Nov 28, 2021

SergeiBaklan , Sir I am attaching the excel file with my data, I have 3 tabs here, Walkin is my daily calling data with their status and all, Shorlisted is where my Final Satus(Column AB) is Selected ,nd t hen joining data for all who has joined .

 

I want to create a PivotTable which give me the journey of a candidate -

-When he was contacted- From Walkin - If he was contacted three-time all the dates

-Date of Shortlising (Column X -from Walkin), this can also be multiple times

- Date of Final Interview (Column AA- from Walkin)

-Date of Joining - from Joining table

 How can I do that with or without Pivot Table

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 28, 2021

ritendersingh2 

Can't say I understood in which form you'd like to have the result and what exactly shall be included. 

Attached is Power Query variant. From my point of view it's more suitable for this concrete task, if only you don't have something else in mind where data model could give more possibilities.

Resources