Hi
I want to merge different pivot table into one pivot table to draw YOY comparison with actual and foretasted and last year. how can i do it.
these pivot table are from different sources an i want to merge them to use with one slicer and want calculate YoY, WOW format is Below. Please help me how can i do it. file is attached please if you can solve in that file will be a massive help.
| SLICES | |||||
| Region | |||||
| Week | |||||
| Month | |||||
| Revenue | |||||
| Actual | v. Target | % | v. LY | % | |
| Affiliates | |||||
| Direct | |||||
| Display | |||||
| Media Partnerships | |||||
| Paid Search | |||||
| Referral | |||||
| Organic Search | |||||
| Social | |||||
| TOTAL | |||||
Hello,
No file is attached. Anyway, my approach would be to get access to all the source data, depending of the quality of the source data, work with any needed modifications using Power Query and from there build the master Pivot Table.
If it is not possible to get hold of the source data, then you should unpivot the data using Power Query again, do needed modifications and then build the master Pivot Table.
How to unpivot is described in this blog post.
Br,
Anders
Hi Ahemed,
Try this tutorial: https://www.myonlinetraininghub.com/combine-excel-worksheets-with-power-query
The Power Pivot solution requires much more explanation and with no sample file we don't really know what you're working with.
Mynda
