UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Compare Year To Year Job Cost By Office - In Pivot ? Chart ?, Office 2013    
 
   
bakersburg9
post Sep 11 2019, 03:17 PM
Post#1



Posts: 5,573
Joined: 2-November 04
From: Downey, CA


This question may be a bit vague, my data analysis skills / pivot table skills are lacking - but the sample data is attached - some key field in my data are AMOUNT, OFFICE and dates how would I show data for cost (AMOUNT) by office, grouped by years, on the cost, showing difference between years, like:

Office 2017 change 2018 change pct change 2019 pct change
Chicago 12,000 18,000 .50% 27,000 50%

Can this be done in a pivot ? charts ? the image is what I currently have in a Pivot...
This post has been edited by bakersburg9: Sep 11 2019, 03:18 PM
Attached File(s)
Attached File  CostNoBilling_Lost_Jobs_WithProgFeeV2.zip ( 1.98MB )Number of downloads: 2
Attached File  OffceCostYearToYearComparisonPIvot.png ( 7.25K )Number of downloads: 0
 
Go to the top of the page
 

Posts in this topic
- bakersburg9   Compare Year To Year Job Cost By Office - In Pivot ? Chart ?   Sep 11 2019, 03:17 PM
- - MadPiet   Which version of Office 2013 do you have? If you h...   Sep 11 2019, 03:28 PM
|- - bakersburg9   MadPiet: Oops - just started working here - it...   Sep 11 2019, 03:31 PM
|- - MadPiet   Steve, If you can DM me the file (strip out anyth...   Sep 11 2019, 03:43 PM
|- - bakersburg9   Mad, Done! Thanks so much ! Steve   Sep 11 2019, 03:57 PM
||- - MadPiet   Steve, Since I'm doing lots of asking... Any ...   Sep 11 2019, 04:27 PM
||- - bakersburg9   Here you go - the query that's exported to Exc...   Sep 11 2019, 04:44 PM
||- - MadPiet   Steve, here's part of it... If you're doi...   Sep 11 2019, 05:33 PM
||- - bakersburg9   Mad - that's awesome! As you know, this i...   Sep 11 2019, 05:49 PM
||- - MadPiet   Oh, so rename the measure, and you're on your ...   Sep 11 2019, 06:00 PM
||- - MadPiet   Steve, When you get around to it, could you class...   Sep 11 2019, 06:32 PM
||- - bakersburg9   Got some fires to put out, then I'll get on it...   Sep 13 2019, 11:48 AM
||- - MadPiet   Okay. Have fun! One bit of advice, though... ...   Sep 13 2019, 12:47 PM
||- - MadPiet   This one shows % of total and some other stuff. Di...   Sep 13 2019, 04:44 PM
||- - bakersburg9   Just each years - but of course, there's been ...   Sep 13 2019, 04:59 PM
||- - MadPiet   The good news is that once you build a good data m...   Sep 13 2019, 05:37 PM
||- - bakersburg9   MadPiet, I REALLY appreciate you jumping in on thi...   Sep 18 2019, 10:27 AM
||- - MadPiet   Okay, now that I have something to play with, what...   Sep 18 2019, 12:05 PM
||- - bakersburg9   Well, first I'd like to see how to automate th...   Sep 18 2019, 12:15 PM
||- - MadPiet   Automate the process of updating the workbook... y...   Sep 18 2019, 01:56 PM
||- - bakersburg9   No, I'm talking about how I'm inputting on...   Sep 18 2019, 02:15 PM
||- - MadPiet   What does the RowNumbers table mean? Are you group...   Sep 18 2019, 02:33 PM
||- - bakersburg9   QUOTE What does the RowNumbers mean ? It's p...   Sep 18 2019, 03:30 PM
|- - WildBird   Yeah, 2016 has more options for calculated fields....   Sep 11 2019, 04:08 PM
- - MadPiet   Found a helpful link for you https://bifuture.blog...   Sep 13 2019, 11:04 AM



Custom Search


RSSSearch   Top   Lo-Fi    22nd October 2019 - 10:07 PM