• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

joining 3 data tables to create one joined pivot in excel

B

brijendraydv

Member
Dear Experts,

I have a requirement where i have there separate reports where all the dimension fields like region,country,location are common to all reports but only the measured fields changes like delivery on time,savings,No of quality products.I need to join all these 3 tables into 1 pivot so that i can just drag and drop and analyze my data.I just searched can power pivot help me in this if yes then pls put some light on this.

Best Regards,
 
Hello Abdul,
Do you think i dont know pivot,my requirement is that i have 3 data sets in different sheet which have many common fields except the measured field like spend,quality products,savings in all 3 diff sheets now i want to have one single report combining all in one pivot.

Regards,
 
You must log in or register to reply here.
Back
Top