A common task in reporting is to compare two date ranges.
The most straightforward way of doing this is with a pivot table, but sometimes you may need to use another method. This blog post will take you through the steps of comparing two date ranges using various methods.04-2013 20-03- 201502-01- 2013– — Date End DateStart ]]xlsx-. namedata–
NameFolder/-Desktop/name_user/Users/://file [[*: Used DataSource* : so like, bottom to top from cells all out fill they until over these drag Simply B”. RangeDate ” title the up take would column second the while”, A RangeDate ” called be should column first The. comparison for columns both select to need will you Then.
data that on table pivot a running then and, rows as data your selecting by method this use can You.
report a in ranges date two comparing of way straightforward most the is This: TableivotP- result endThe .; report that for table pivot the generate to OK click once labels column our created have you After – Four Step;ations aggreg reports your in it include to order in fields these of one onto Date Drag – Three Step);
Month (els Lab Row or) Mar Feb Jan.,g.e (els Lab Column),TD Y.,g.e ( Name FieldTableivot P desired your Choose – Two Step; tab Insert the from” TableivotP “ Select – OneStep : steps following the through go then and report your select first, this do To. axis each on ranges different two with aggregate an create tooted piv be can data other as well as date the, table pivot a In- add to is step nextThe :
ets She Google or Excel within together them viewing when side by side up line they so B below Date in those match they until like would you if title heading column any Change.
appears that menudown drop the from Values select then and once” ADate “ on click, this do To). ADate ( dimension each for valuesisAx- X of set a create to times’ it, table pivot the in fields date two are there that Now. field new this into fields date both drag, Next. metrics and dimensions desired your with field empty an create to need will you, First. report a in ranges date two compare to ways easiest the of one is table pivotA