Calculate using an Averaged coumn in a pivot

Posted by Emily Y on Super User See other posts from Super User or by Emily Y
Published on 2010-04-20T18:40:14Z Indexed on 2010/04/20 18:44 UTC
Read the original article Hit count: 328

Filed under:

id

Hi,

I have a pivot which includes goals and year results. Because goal is the same on each meausure, I have to average the goal in the pivot in order to show the correct amount. I then want to calculate v% between the goal and the year result. Because the goal is averaged, v% cannot be calculated correctly. Does anyone know of a way to do calcuation like this in a pivot?

Thanks a lot, Emily

Related posts about id

# id - urls with id first display full page, then move to #id

as seen on Pro Webmasters - Search for 'Pro Webmasters'
I've noticed this in the new version of chrome, and ie9 and 10. Some urls in a photo gallery have a #id tag as they are supposed to display a full view of a picture. Basically, a div in a lower position on the page has that #id that i call via a.com/1.html#id. This has never been an issue until… >>> More
I have finally traded my Blackberry in for a Droid!

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Over the years I have used a number of different types of phones. Windows Mobile, Blackberry, Nokia, and now Android. Until the Blackberry, which was my last phone (and I still have one issued from my office) I had never found a phone that “just worked” especially with email and messaging. The Blackberry… >>> More
change USB vendor id / product id

as seen on Super User - Search for 'Super User'
Under Windows, is there any easy way to change or forge the vendor and product id of a USB device? Say for example there's a useful program which expects a particular (but ubiquitous and generic) device but you think it will probably work with the device that you actually have. I've done lots of… >>> More
How can I create a weekly calendar view for an Android Honeycomb application?

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on an Android (v3.0) application that has a requirement of mimicking the weekly calendar layout found on Google Calendar: The events will be based on external requests through the Google Calendar API (I already have this part working). Using the API, I can obtain a list of events for… >>> More
App ID and Bundle Seed ID in multiple applications with ASPN, InApp Purchase, and other

as seen on Stack Overflow - Search for 'Stack Overflow'
I will create multiple sale versions of the same application with push notifications feature: CoolApp (full version) CoolApp Free (free, features limited version) CoolApp InApp (free version upgradable to full via InApp Purchase) While registering for App ID in Apple Program Portal is possible… >>> More

Developer IT

Calculate using an Averaged coumn in a pivot - Developer IT

Calculate using an Averaged coumn in a pivot

id

Related posts about id

# id - urls with id first display full page, then move to #id

I have finally traded my Blackberry in for a Droid!

change USB vendor id / product id

How can I create a weekly calendar view for an Android Honeycomb application?

App ID and Bundle Seed ID in multiple applications with ASPN, InApp Purchase, and other

Categories cloud