Microsoft Office Forums Pivot table- % growth and difference between two items in same column by months

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-27-2019, 08:28 PM
sarana sarana is offline Pivot table- % growth and difference between two items in same column by months Windows 10 Pivot table- % growth and difference between two items in same column by months Office 2010
Novice
Pivot table- % growth and difference between two items in same column by months
 
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 Pivot table- % growth and difference between two items in same column by months Windows 10 Pivot table- % growth and difference between two items in same column by months Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,029
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
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 Pivot table- % growth and difference between two items in same column by months Windows 10 Pivot table- % growth and difference between two items in same column by months Office 2010
Novice
Pivot table- % growth and difference between two items in same column by months
 
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- % growth and difference between two items in same column by months Pivot Table: Show Data For Multiple Items jhato160 Excel 14 08-01-2016 11:24 AM
Pivot table- % growth and difference between two items in same column by months 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 08:31 AM.


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