Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-27-2019, 08:28 PM
sarana sarana is offline Windows 10 Office 2010
Novice
 
Join Date: Jan 2019
Posts: 6
sarana is on a distinguished road
Default Pivot table- % growth and difference between two items in same column by months


Need help on pivot table. I am trying to find % growth between two numbers in same column for different months and different categories instead of grand total of row. Any help will be appreciated. Thank you
Attached Files
File Type: xlsx example.xlsx (17.5 KB, 6 views)
Reply With Quote
  #2  
Old 01-28-2019, 12:45 AM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,005
xor is just really nicexor is just really nicexor is just really nicexor is just really nicexor is just really nice
Default

Maybe the attached can be of help.
Attached Files
File Type: xlsx Pct_Increase.xlsx (17.7 KB, 4 views)
Reply With Quote
  #3  
Old 01-28-2019, 06:42 AM
sarana sarana is offline Windows 10 Office 2010
Novice
 
Join Date: Jan 2019
Posts: 6
sarana is on a distinguished road
Default

Thank you. There is extra column that shows up and not sure there is any other solution to that. Really, appreciated if anyone can help
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table: Show Data For Multiple Items jhato160 Excel 14 08-01-2016 11:24 AM
How to vba pivot table to deselect items but sometimes one item may not be there mbesspiata3 Excel Programming 1 04-22-2016 07:32 AM
Include and Exclude items through vba in pivot table mbesspiata Excel Programming 0 02-22-2016 12:30 PM
Selecting/deselecting items in pivot table mbesspiata Excel 0 07-22-2014 08:15 AM
VBA Pivot Table CubeField Enable multiple items Wries Excel Programming 0 03-13-2014 09:56 AM


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft