Press Alt-D-P to run the pivot table wizard.
Chose "Multiple Consolidation ranges" and "Pivot Table" then click Next.
Choose "I will create the page fields" then click Next.
Enter range Blad2!$A$3:$B$6700 and click Add.
Enter range Blad2!$D$3:$E$8495 and click Add.
Click Next.
Choose "Existing worksheet" and enter range Blad2!$K$2.
Click Finish.
This will give you a third pivot table, which combines all the Rijlabels values from your first two pivot tables, and shows both Sec values.
Right click on this new pivot table, choose "Pivot Table Options", select "Totals & Filters", and untick both Grand Totals boxes. Click OK.
Now, in cell N4, enter: and copy down.
Done!
Bookmarks