Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-05-2015, 02:59 PM
gebobs gebobs is offline I can't figure out getpivotdata for my monthly budget Windows 7 64bit I can't figure out getpivotdata for my monthly budget Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

See how this looks for you. I've grouped the data by month and year. To do that, you right click on any of the date values (so for here, you would right click either Jan, Feb, or Mar in row 3) in the pivot table and select Group. You can also filter by a specific month.
Attached Files
File Type: xlsx BudgetPivot.xlsx (16.6 KB, 11 views)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
budget reports in MS Project Professional 2013 shuttlebust Project 1 11-17-2014 05:42 AM
I can't figure out getpivotdata for my monthly budget Budget cost on early stages Baddim Project 9 10-30-2014 03:06 AM
Caption Order: Figure 4 Figure 3 Figure 2 golfarchitect13 Word 5 05-07-2014 07:15 PM
I can't figure out getpivotdata for my monthly budget How to apply budget for earned value analysis ttorneby Project 2 06-03-2010 04:52 PM
Income/Budget Calendar? Guinea Excel 4 03-11-2010 09:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:57 PM.


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