How to compare two pivot tables

[Syedali]

Hi,

How to compare two pivot tables.

Or how to pivot two pivot tables??? Attached sheets for you reference.

 

[vletm]

Syedali
Could You write more details, what are You looking for
or
Could You use this?

 

[Syedali]

Hi,

I have attached with another sample,

i have same value but it is not in order (asc or dsc) You can see in attached file.

I want to compare this.

 

[vletm]

Syedali
... compare ... compare ... compare ...
but what would be needed result
if not, for some reason, that You can see there now?

 

[Syedali]

Syedali
... compare ... compare ... compare ...
but what would be needed result
if not, for some reason, that You can see there now?

I found result thank you ....

 

[Syedali]

I found result thank you ....

And it is my mistake for summarzied my question properly @vletm

Result.

Edit:

While using INDEX MATCH am facing REF! error. I don't know why it is occurred. Not urgent kindly look into this.


Thanks respected @vletm

 

[vletm]

Syedali
Your the newest file ... what would be connection with this case?

 

[Syedali]

Syedali
Your the newest file ... what would be connection with this case?

am extremely sorry wrongly uploaded file .