Hi,
I am lookin for a solution, where i need to create a pivot table with 2 sheets data.
Data in both sheets are same except month. My first sheet is full populated till last row.
we have option of consolidate sheets and create pivot table but i am not getting what i want.
we want area,category and region in filters above which is not happening.
Can any one provide any solution to the same.
Thanks