• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Compare week to week when dates are all in one column?

C

Cruiser

Member
The attached example, "ProduceData" contains a single worksheet with 4 weeks of five-column-records. Basically a flat database. 1 column is "Date". Without changing this format, Can I create a pivot report to compare ranges of dates (all dates being in the same column)? Examples: How many times did Kroger buy onions in week 2 (8th through the 15th)compared to week 1 (1st through the 7th)? How many total orders did Winco place in week 4 compared to week 3? I can create a pivot table for ONE period, but how can I compare two periods? To be clear, I do not want to reformat the original data.

Can someone point me to a good example or tutorial of how to make this happen? I don't care how much work it is for me to set up, my only concern is that it is simple for the end user.
 
Nebu said:
I am not sure whether I understood your question... Could you be a little bit more specific...
Click to expand...
You dragged "Product" and "Date" into Row. The resulting pivot report has a column for "Date" after the "Product" column. When I do the same thing, the resulting pivot report has "Date" in the same column as "Product". How did you get "Date" in its own column?
 
Click on the pivot and look at the pivot table field list, see the order in which I have put the product and the date, replicate the same for your pivot...
 
Cruiser said:
The attached example, "ProduceData" contains a single worksheet with 4 weeks of five-column-records. Basically a flat database. 1 column is "Date". Without changing this format, Can I create a pivot report to compare ranges of dates (all dates being in the same column)? Examples: How many times did Kroger buy onions in week 2 (8th through the 15th)compared to week 1 (1st through the 7th)? How many total orders did Winco place in week 4 compared to week 3? I can create a pivot table for ONE period, but how can I compare two periods? To be clear, I do not want to reformat the original data.

Can someone point me to a good example or tutorial of how to make this happen? I don't care how much work it is for me to set up, my only concern is that it is simple for the end user.
Click to expand...
To anybody following this thread: From my original post, the line,"Can I create a pivot report to compare ranges of dates (all dates being in the same column)? " may not be completely clear. What I mean to say is, "Can I create a pivot report to compare ranges of dates ( SINCE all dates ARE in the same column OF THE ORIGINAL DATA)? " I do not mean to imply that I must have all dates in the same column of the pivot report. In fact, that seems counterintuitive since my goal is to COMPARE different weeks. I would like for the user to be able to simply select the product(s) and periods for comparison. Then the pivot report will automatically display the difference and percentage of difference. I can find many examples of this type of report in various excel forums, but in each case the reporting periods being compared are in different columns or even different worksheets. The fact that my data has all of the dates in one column is what makes my situation different.
 
Last edited:
Nebu said:
Click on the pivot and look at the pivot table field list, see the order in which I have put the product and the date, replicate the same for your pivot...
Click to expand...
Nebu, thank you. I have already done just as you suggest when I created a new pivot table on the same sheet below yours. My pivot table field list looks exactly like yours with Product and Date both in the Row field. However, in the report, my dates are in the same column as product, where yours have a product column and a date column. I would like to replicate that, but I don't know what needs to be changed. Any idea?
 
Can you Upload your file real quick , its Friday 7:30 PM here :), if you can upload quick I can fix it and upload back for u.

Thanks
 
You must log in or register to reply here.
Back
Top