Thread: [Solved] Novice to Pivot Table: Need help to generate a report in a predefined format
View Single Post
 
Old 09-08-2014, 08:30 AM
Himansu Himansu is offline Windows 7 64bit Office 2010 64bit
Novice
  
Join Date: Sep 2014
Posts: 2
Himansu is on a distinguished road
Default Novice to Pivot Table: Need help to generate a report in a predefined format
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.
Attached Files
File Type: xlsx Temp PT.xlsx (15.6 KB, 15 views)
Reply With Quote