• 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.

Pivot Table - Group by several date sets

G

Griphus

New Member
Hi,

I have a spreadsheet of customer orders, price, and three date sets (required delivery, aggressive planned delivery, and conservative planned delivery).

I have a pivot table set up showing me count & sum of price grouped by month of aggressive planned delivery.

I'd like to see count & sum of price for each of the three date sets next to each other. I think this would require some sort of enforced row label... but I can't figure out how to make it happen. Can anyone help?

Thanks much,
Timothy
 
Good day Timothy

You can right click on a date and select group by date, but an upload would be better so we could see how the PT is setup
 
No problem. I already have it grouped by date. I'm actually looking to group by several dates across columns. I've pulled out all the sensitive data and attached it here - you can see what I have, and I made a tab with static data showing what I'm trying to do.

Thanks very much,
Timothy
 

Attachments

Hi Griphus,

Its morning 6 oClock here, and just came from my Office, still tried to demonstrate as much as possible.
Please have a look, and let us know the feedback.

 

Attachments

Last edited:
Hi Timothy ,

After seeing Debraj's file , I realised I had misunderstood your problem ; the same file I uploaded earlier has been revised. This is just in case you don't mind a formula solution.

Narayan
 

Attachments

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