Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot Tables

Pivot Tables

ResolvedVersion 2007

Sun 2 Sep 2012, 12:33 Delegate Bryan said...

Bryan has attended:
Excel Advanced course
Excel Pivot Tables course
Excel Advanced - Formulas & Functions course
PowerPoint Intermediate Advanced course
Emotional Intelligence at Work course

Pivot Tables

I want to be able to use 2 dates so i can cross-reference a before & after scenario. Within Pivot table i can see a date but even though i click on 2 separate dates i'm only seeing one of the dates visible wihtin the Pivot table...I would appreciate some assistance.

Kind Regards
Bryan

Mon 3 Sep 2012, 16:40 Edited on Mon 3 Sep 2012, 16:41 Trainer Rodney said...

RE: Pivot Tables

Hello Bryan,

Hope you enjoyed your Microsoft Excel PivotTable course course with Best STL.

Thank you for your question regarding cross referencing two dates in a PivotTable. It would be most helpful if you will send me a sample file so that I can digest your question and give you my answer.

Can you also explain why you want to create this particular scenario and give any other details you may think necessary.

My email address is: rl@stl-training.co.uk

I look forward to your reply.

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Reconciling a list to correspond with another

May have a list that needs to make but on another sheet one list seems to be out, eg. product list one sheet contains all product and inventory data, while the other contains pricing data. Both need to match with all products but there is more products in one list than the other. To find the disparaging product compare data in the two columns that need to match Make sure that order the same way.
Create another column in the sheet that has the most items and type in the first cell

=Exact(text1,text2) text1 being the cell that you want compared with text2 cell reference. Drag to filldown and your first false will give you for first cells that does not match. Correct insert the row with data in other sheet and continue the process until all the data returns true. Delete the column inserted.

View all Excel hints and tips

Pivot Tables

Pivot Tables

RE: Pivot Tables

Excel articles

Excel tip:

Reconciling a list to correspond with another