Pivot tables counting

[johan fox]

I have identical numbers in one excel, left is old report, right is new report.
Now what I need is the differences between the two sitiuations. So, the difference between left and right.

Left is A -- identical number with right next to it old usage in seconds.

Right is D -- identical number with right next to it new usage in seconds.

What I'm searching is the difference between thise two.

So I need two new collums right next to it or in a new tab with:

every number 1 time with total sec right behind it right minus left

I made an example of the wanted results in G / H / I

Hope someone can help me with this?


oud rapp nieuw rapp draaitabelvb.xlsx

[Olly]

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:

=M4-L4

and copy down.

Done!

[johan fox]

Thanks a lot! It works great!

[johan fox]

I can't get that one unfortunately, can you do that in the sheet and put it back here OllyXLS?
Alt-D-P and nothing much happens here...

[Olly]

Sorry - I can't upload files from this computer...

Alt-D-P is the keyboard shortcut I used to open the Pivot Table Wizard - I'm guessing your Dutch keyboard shortcuts are a bit different!

Unfortunately the Pivot Table Wizard was removed from the ribbon / menu from 2007 onwards. Microsoft provide the following tip, to get to this Wizard in 2007 onwards:

To add the PivotTable and PivotChart Wizard to the Quick Access Toolbar, do the following:
1.Click the arrow next to the toolbar and then click More Commands.
2.Under Choose commands from, select All Commands.
3.In the list, select PivotTable and PivotChart Wizard, click Add, and then click OK.

[Olly]

Great

If your question has been answered, please mark your thread SOLVED. You may also wish to add reputation to those who helped you.