Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-08-2014, 08:30 AM
Himansu Himansu is offline Novice to Pivot Table: Need help to generate a report in a predefined format Windows 7 64bit Novice to Pivot Table: Need help to generate a report in a predefined format Office 2010 64bit
Novice
Novice to Pivot Table: Need help to generate a report in a predefined format
 
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, 13 views)
Reply With Quote
  #2  
Old 09-11-2014, 02:00 AM
Himansu Himansu is offline Novice to Pivot Table: Need help to generate a report in a predefined format Windows 7 64bit Novice to Pivot Table: Need help to generate a report in a predefined format Office 2010 64bit
Novice
Novice to Pivot Table: Need help to generate a report in a predefined format
 
Join Date: Sep 2014
Posts: 2
Himansu is on a distinguished road
Default

Some suggestion will really help guys

Well I tried Access also, seems like we cant do a FULL OUTER JOIN there.
Reply With Quote
  #3  
Old 10-26-2014, 03:57 PM
p45cal's Avatar
p45cal p45cal is offline Novice to Pivot Table: Need help to generate a report in a predefined format Windows 7 32bit Novice to Pivot Table: Need help to generate a report in a predefined format Office 2010 32bit
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

See attached, new pivot below your Ideal report.
I've copied the Revenue data below the Order Book data and used that one table as a data source for the pivot.
Attached Files
File Type: xlsx msOfficeForums22607Temp PT.xlsx (19.9 KB, 11 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table uhlersa Excel 0 10-15-2012 12:01 PM
Novice to Pivot Table: Need help to generate a report in a predefined format creating a report table kannan Word VBA 5 05-02-2012 04:11 PM
Novice to Pivot Table: Need help to generate a report in a predefined format pivot table aliasadi_07 Excel 1 03-11-2012 12:49 AM
Novice to Pivot Table: Need help to generate a report in a predefined format 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:29 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft