Hi,
I have a spreadsheet with three columns for a billing date range, column A being the from date and column B being the billing end date, column C being type of contract. Ideally I'd like a pivot table with the billing types down the x axis and calender months/year across the y axis. Can I produce such a pivot where the date range is in two columns rather than one date? Completely baffled how to do this. Can anyone help?
Thanks in advance
John
I attach a screen shot of what I need which will help. Sorry the amounts aren't aligned with the months, I save it but it goes wonky again. Also, the source data actually has the date in one column rather than two but its the pivot creation I need;
type DATES amount
Meter 11/11/2008 - 01/01/2009 150.00
Click 02/12/2008 - 03/02/2009 500.00
Pivot Dates
Type Aug-08 Sep-08 Oct-08 Nov-08 Dec-08 Jan-09 Feb-09 Total
Meter 21.88 31.25 32.29 31.25 32.29 1.04 0 150.00
Click 234.38 242.19 23.44 500.00
Last edited by John4444; 01-09-2016 at 01:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks