Novice to Pivot Table: Need help to generate a report in a predefined format

Himansu · #1 09-08-2014, 08:30 AM

Hi,

I am having a hard time understanding Pivot Table, but i guess, it is the best option for the solution that I aspire for.

Please check the attached excel file.
There are 4 sheets, the "Rev" and "Order Book" are the input sheets and "Sheet 2" is what I get using wizard. I want to get the result as in "Ideal Report".

Someone please guide me. Can we achieve the ideal report using Pivot table or what is the next best option.

Thanks a lot for your time, really appreciate your help.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Table	uhlersa	Excel	0	10-15-2012 12:01 PM
creating a report table	kannan	Word VBA	5	05-02-2012 04:11 PM
pivot table	aliasadi_07	Excel	1	03-11-2012 12:49 AM
Help with a pivot table please!	natsha	Excel	1	02-16-2012 12:41 PM
CPU maxing out after using predefined Table Styles	azdolfan	Word Tables	9	06-07-2010 05:06 AM